Data from unrelated table in menu?

[romenov]

Hi,

My current database links a person to an establishment , and the establishment links to the main company information. I am however trying to make it so that in my view of a person, when I create a record, that I have a list of companies which I can select, and upon selecting one, the establishments of that company are shown so that I can select that (and thus making the link between person > establishment > company)

I am however unable to get the companies to shows when I add a pop up menu or sorts with a Unrelated table, however when I click it. Filemaker gives me an error that it's not related (why give me the option of selecting an unrelated table)

Kind regards,

Maarten

[comment]

See if this helps:

SubgroupVL.zip

[romenov]

That was exactly what I was looking for, tx !

May I ask how you made it so that when I select a continent, I automaticaly get sent to the next box? I can't find a script in that database that does that!

Thanks

[comment]

Tab order.