I am looking for help creating a table-to-table relationship that is not based on a common Key Field.
I need to import table data from an external source on a regular basis. For each of the imported records to Table #1, there is a text field (not the Key Field) that will match a text field (also not a Key Field) from another table (Table #2). There may be multiple record in Table 1 that relate to each record in Table 2 (and not vice versa). I am having trouble linking these tables since I am not able to use the Record ID / Key Fields which is what QB wants to use to join them. The data source that I am importing from does not know the relevant Record ID of the matching Table 2 record in my QB database. Any suggestions on how to achieve this relationship? TIA