Web-like popup menu

[Kee Yung]

Hi,

this might be a very stupid question but I'm not a FMP wizard. Thanks for your understanding.

I want to do a pop-up that "shows" certain values but store others. For example, the user choose between A, B and C but the value stored is 1, 2 or 3. Pretty much like it does in html: <option value=1>A</option> and so on.

The reason I want to do that is because I have a CDs database and a Bands database. Each band has a unique ID and a name. In the CD database I want a pop-up to choose the band by name, but it's the ID I want to store, so that if I made a spelling mistake in the Bands database and correct it, the relevant CDs now shows the corrected name.

I'm not sure if that's clear.

Basically, I store the band ID in the CD database, but to choose it, as I won't remember each band's ID number, I want to display the band's name.

Any help?

Thanks in advance.

K.

FileMaker Version: 6

Platform: Mac OS X Jaguar

[H.P.]

I am not sure if this work in filemaker 6 or not but you could still try:

On the field you want ID, the selected value will be in ID.to display, go to field format, and then select pop-up list or pop-up menu, and then choose "List value from fields", select field 1 to the ID field, and second field the name. When the user selects, the field will list both name and

Now, make the field transparent and add the name field on top of the transparent field. After you done those steps, It will work similar to the web.

I'm a newbie also, so maybe someone else has a more elegant solution to your problem.

FileMaker Version: 7

Platform: Windows 2000

[Kee Yung]

thanks,

that will do the trick for me!