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

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)