Value List - (selected values)

[Creek]

There is a table with three columns: ID, CODE, TYPE. ID – number (serial number), CODE – text (unique name), TYPE– text: ("Type A" or "Type B")

The aim is to create a value list based on the records from the table, where TYPE is “Type A” only. How to do it?

[doughemi]

1. Create a new global field gType.

2. Create a new Table Occurrence of your table named newTO

3. Relate the new TO by the relationship YourTable::gType = newTO::TYPE

4. Create a new value list(Use Values from newTO::CODE, include only related values starting from YourTable)// Assuming the values you want to see in your VL are the Code values

5. Set Field(YourTable::gType; "Type A") either manually or by script

[Creek]

Exactly what I was looking for. Thank you very much for your help.