Linking Table Error

[jdstew]

I have 2 files I need to link by 2 columns. I uploaded links to sequel tables but everything needs to be linked by site and supplier ID

it won't let me do it. site (thousands of lines) and supplier ID (thousands of lines) so - many to many - but that isn't an option. The site / Supplier ID combination is unique. Is there a way to do this? (example - the same supplier ID could be used for a different supplier - by site) so I have to be able to link them together for reporting.

[jdstew]

I have 2 tables I need to link by 2 fields.

Site / Supplier ID - each site "could" use the same supplier ID for a different supplier - so those 2 fields need to be linked to make the relationship unique. Is there a way to do that?

[zoloturu]

@jdstew, can you show some sample data? Just few rows per each of 2 tables.

[jdstew]

example: Table one includes Site / SupplierID / Supplier Grouping Table two includes Site / SupplierID and any number of other things (ex: Spend) I need to link - the SQL tables by Site and Supplier ID because those have to be the same and then be able to pull data by the Supplier Grouping and any number of the other things (ex: Spend) Maybe Concatenate would work but the SQL table has a million lines...so I can't make it a table - I need the linked version so it stays current because the data in these tables is updated frequently.

[zoloturu]

@jdstew,

If your question regarding tables it would be more clear for us to see example tables. Please create those in Excel and send a screenshot of that. Several rows will be enough.

[Greg_Deckler]

Would have to see some sample data and relationships but in general you would create a custom column that concatenates those two values to create a unique key. You would then create a separate table where you only import this custom column and only bring in the distinct values. You can then use that table to relate it to your other two tables.