I am creating a QV document using tables from the US Census Bureau. All the the tables have three fields in common (ID, ID2 and Geography). I have a "Main Data" table and trying to connect it to the other tables. However, with only those three fields in common it seems there are no other unique fields by which to associate them. I have created one unique key (ID & '|' & ID2 & '|' & Geography as [%Key Field]), but that only links two tables together and leaves the others without a unique key by which to link them. Any thoughts?
