lookup value list

[yaron]

I want to have a drop down field that has values from another table based on a mach between the tables.

can it be done?

deeper explanation:

I have table A with field "name", filled with 100 records,

I have a form where I also have a field "name" , then I want another field called "family name" to be used with drop down list where the "name" here matches the "name" in table A

can it be done?

[Fitch]

In Define, Value Lists select "Use values from field" and under the list of fields select the "Include only related values" option. You will need to have made a relationship between your "name" fields for this to work.

[yaron]

Not yet solved - I made the relationship between the fields (draging one to the other and now I see in the graph the relationship)

but when declaring the value list -> use values from field - here I put the field from the table A (the one from where I need to take the data)

and what shoukd I put in "Include onlt relevant values from" drop down? the second table I guess. but it doesnt work.

[yaron]

Im getting confused between the database/value list declaration & the layout building.

In the layout - there is display data from & display values from.

what should I put in each of them?

[yaron]

well the solution was to leave the "include only values from related data" radio button - selected & with "unknown"