Jump to content

This topic is 7278 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted

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

This topic is 7278 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.