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?

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.

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.

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?

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