I have a connected table getting sale data from a CSV file in the Google drive. I must have a unique ID in this table, therefore I added one as Sale ID. I do have a store number but as this is linear data by department my store number cannot be unique.
In order for me to report this sales data together with other Store info, I need to connect this table to stores table.
Now the issue is that my stores table has a lot of relationships and in all relationships, I am using record ID # as the key field. This is appropriate as I may not always have a store number until a project is established in SAP.
Now when I am trying to link my stores table to Sale data, I cannot do so as record ID # in stores table is not relevant to store number in the sales table. Unless there was an option to have more than one key field, I cannot seem to find the way to link to the connected table. Any insights?