Many-to-Many, Help

[pulse]

I am using FileMaker 6.0 and am new to FileMaker. I have three tables in a many-to-many relationship. (Vendors -< Ven_to_Prod >- Products) I want to be able to select three vendors for a product on the product page and select one as a primary vendor (check box). I also only want to show the vendor name in a pop-up list (not the vendor id). I can't seem to figure out a way to use the vendor name and have the vendor id entered into Ven_to_Prod. I am currently using a portal on the Products Layout to enter this information. Thanks for your help.

Pulse (a.k.a josh)

[falkaholic]

In the Ven_To_Prod table, make a new calculation field that does Products::Product_Name

Then in the Vendors value list, have it so the ID field and the new calculation field. Then the name should show when you have the pop up popped up, it will show the ID and name.-- but once its not, only the ID will show. Theres new real way around that. Run a search on these forums for some hacks aorund it.

HTH

[pulse]

falkaholic

I was able to figure that much out, but I dont want the user to know that an ID even exists. And when you look at the portal after your selection is made for vendor, seeing the ID will not help the user.

-josh

[falkaholic]

The work around I did once was to make a calcuation field to put ontop of the pop up that shows the name o the current ID. Make the background non-transparent, set the pop up to a pop up list instead, and make the field a button that does a Go To Field [popup_list_field].

That way the ID stays behind the calculation field. But the user will still see the ID in the pop up.

What I do now is to have the user select from a portal. It allows you to show any number or kind of field to the user.