Hi,

I have 3 databases: A, B, and C. In one layout of A, there is a portal to display/edit records of database B, and the field format of one of the fields in the portal is assigned as an pop up value list, and this value list is a long list, contains about 20 items. And the items of this value list are come from database C (there are 20 records in database C)

And the rule is that the item in the value list is to be selected ONLY ONE TIME per record. In database B, I can setup a SELF-relationship to detect if there is a duplicated item.

But I would like to display the word “selected” side by side of the item in the pop up value list to indicate that the item is already selected.

Any advised?

Thank you.

quote:

---

Originally posted by LuckyMe:

Hi,

I have 3 databases: A, B, and C. In one layout of A, there is a portal to display/edit records of database B, and the field format of one of the fields in the portal is assigned as an pop up value list, and this value list is a long list, contains about 20 items. And the items of this value list are come from database C (there are 20 records in database C)

And the rule is that the item in the value list is to be selected ONLY ONE TIME per record. In database B, I can setup a SELF-relationship to detect if there is a duplicated item.

But I would like to display the word “selected” side by side of the item in the pop up value list to indicate that the item is already selected.

Any advised?

Thank you.

---

Hi Lucky,

let' s suppose to have the following scenario:

- in file C build a relation between the field used used to create the popup in the file B (we name it as 'item' in both files B and C)

- create in file C a new field and name it 'check'; this would be a stored calculated field containing the following formula:

Case (relation::item = item, "X", " ")

this will automatically flag the selected records

- change the popup including in it, as first field, the 'check' field: so the user can immediately see the checked items.

HTH

Regards

[ April 09, 2002, 12:49 PM: Message edited by: JPaul ]

Hi JPaul

Thank you for your information, but I am afraid it is not work the way I want or maybe I did not make myself clear?

Anyway what I want is to display “X” on selected items based on a SINGLE record and based on relation of A and B. Otherword if that item is selected, then it will display “X” for that record, but not the other records (if it is not selected). Your method will show “X” for every records in the database. I think I should give you an example:

For example:

Let’s say A related to B by a field called ID Number. Using this relation, I display multi records of B on A by using portal placed in layout of A. In the portal, there is a field of B called Item, and when you click on item, it gives you a drop down value list, this value list comes from database C.

Let say the value list will looks like this

123

456

789

011

…..

Now you are looking at the portal in database A, when I click on Item and select 456, then when I click the item again, it will display X beside 456. Now still in database A, if I browse to ANOTHER record, and click on item, the “X” should NOT be displayed beside 456 because 456 is NOT selected yet of the current browse record.

I hope I make myself clearer this time. What do you think?

Thanks again.

Hi Lucky, if do you agree, send me the files via e-mail (see my profile)with a little comment.

Regards