Hi FMForums,

I have created my database so that records from one table are linked to records in another based on a unique id number: a basic "many-to-one" relationship. I want to make it so that when a user gets to associate their new record with a record from the other table, they can choose from a pop-up menu of all the possible items from the other table. This is easy in the FM App: Just make a value list that displays both the ID and name field from that other table.

However, the second value (the name field) doesn't show up in that list when its published on the web! What technique do most people do to overcome this limitation? This seems like it must be a very common issue. Any suggestions on a better way to design this kind of thing? If this were a web app and I was using something like PHP and SQL it would be ridiculously easy.

Thanks!

-Eric

You can use PHP with filemaker as well.. (if you have server advanced, you can use the fx.php class to build your own web pages with whatever you want in the popups.

In IWP, you could use a portal instead of a popup to display the values, and use a scripted button in the portal row to assign the FK.

Dana