Newbie - Relationship & Dropdown Help

[BeachDave]

I have two tables - PROPERTY and MANAGER. Each contain a MANAGER_ID field and the two are related using these fields.

I also have a PROPERTY layout. It lists all the fields in the PROPERTY table ... one of which is MANAGER_ID.

I want the user to see a dropdown box with MANAGER_NAME (the contents of which should come from the MANAGER_NAME field in the MANAGER table).

Once selected this dropdown box would populated the MANAGER_ID field in the PROPERTY table with the MANAGER_ID corresponsing to the MANAGER_NAME choosen by the user.

I can't seems to make it work. I hope that wasn't too confusing. If so I can provide clarification. Thanks.

BeachDave

[Wim Decorte]

The value list "managers" should have the ID as the first field and the name as the second field and be set to show only the content of the second field.

With this done, the dropdown box will show the name of the managers but put the ID in the field.

A pop-up menu will show the name instead of an id after a selection is made but the field will still hold the id.

manager_property.zip

[BeachDave]

Thanks Wim. I took a look at your file. Is this the only way to implement? It doesn't seem very elegant. Not your solution but the way FM handles this type of scenario. Is there any work around at all to make it so the user only sees the Name and not the ID? Thanks.

[Wim Decorte]

Like I said in my earlier post, if you use the pop-up value list the user never sees the ID, just the name. You wouldn't show the ID field like I have in the demo.

If you want to use the drop down then you basically overlay the manager::name field on top of the ID field so that when the make a selection the name hides the ID field.

[BeachDave]

Got it. Thanks.