If you do nothing, tables A and B will be automatically connected by QuoteID. No need to load table C. If you really want them in a single table:
INNER JOIN (TableC)
DROP FIELD QuoteID;
Edit: And I mean do this INSTEAD of loading tables A and B.
Thank you Jon for your reply.
I follow your positings and figuered I will "hear" from you.
Alas, I do need the other 2 tables on their own and the 3rd one should be separated. The structure of my data (currently some 35 different tables from many complex views in SQL) are too complex to wade and weed through.
When time is right I believe I should revisit the whole structure and do the right things to it.
Alas, I do need the other 2 tables on their own and the 3rd one should be separated.
OK, then do what Lucian suggested, but rename the fields as you load them in, or use QUALIFY to do it automatically. Otherwise, all the fields will connect to each other since they have the same names.