drop down list -> show value, return ID?

[matt35]

Hi,

I'm somewhat new to FM, but sort of an old-hat with relational databases. One functionality I'd *love* to have in FM is a select list (drop-down menu) that will show the value of a related field at all times, but actually store a return ID in the field of interest. Both MS Access and Oracle have this kind of thing, which makes development of portal records to related tables easy. For example, a table of 'People', and a related table of 'relatives'. let's say you have a relationship between a FK field Relatives::PeopleID tied to People::PeopleID. In a front end, I'd like to show a list of relatives for this person. It seems with FM, you need to have one pick list for the ID (which shows the name upon expanding, but reverts to the number when not expanded), and another to show the name?

Any help is appreciated.

Thanks!

Matt

[overrider]

you can just select the related record id when making your value list. so when you click in a field it shows 001 Peter , but when you select it, it shows just 001. you can also have it the other way, at least filemaker 7 and later, so it hides the related id, thus just shows the name

Edited March 13, 2006 by Guest