Hello, i am creating an inventory database to store item stock as well as keep track of suppliers. I currently have a portal that shows all available supplier parts No's and prices. I print barcodes

Hello, i am creating an inventory database to store item stock as well as keep track of suppliers. I currently have a portal that shows all available supplier parts No's and prices. I print barcodes that go with each of these items to be places below the item on the shelf. I would like to include the manufactures part number and price as well. The problem is FileMaker chooses for itself what supplier link to use, currently the supplier name and part number do not reflect the same record (BAD). Right now it chooses the lowest SupplierID and lowest SupplierPartPricesID, not neccessarily from the same record link, one can only see the problem when theres more than two supplier links and with certain conditions.

I have a supplierpartprices table linking the inventoryItem and the supplier table. I have been playing around with a new table entry in inventory called PrferredSupplier but i have not had any success creating a value list to generate from just the member in the portal view.

I have attached a simplified database for your toying pleasure. Any recommondations are welcome as this is just being developed as well as any other methods to get the supplier prices to print with the right supplier name.

Inventory.zip