Add multiple suppliers under same product

[Fleet_Cruisin]

Hi

I want to add multiple suppliers to under same product. The product id is calculated based on branch location and it will be unique. But Product barcode is same.  Which means different location unique product id but with same product barcode products can be. Same barcode will be in different branch locations. Multiple suppliers are adding based on product barcode not based on the branch. So in my product table Product ID is key.  So how to add multiple suppliers with extra 2 more columns. 

Thank you.

[TeeSee1]

This is a data modeling question not an AppSheet one per se.

I would model it with five tables.

products: product_id(=barcode), additional attributes (standard price, color, UOM, etc),,,

product suppliers: generic_id, product_id, supplier_id, additional attributes (i.e. supplier specific purchasing price)

location dependent products info: id(= location_id+product_id), attributes specific to this table id (i.e. location dependent stock)

suppliers: supplier_id, additional attributes(name, address, etc)

locations: location_id, additional attributes(name, address, etc)

But then again, it should depend on your business model so this is just an example.