Unanswered: Table linking/relationship "How do I" question
I will do my best to explain what I need to do here.
I have a contact table that contains contact code, names, addresses, type of contact (client, broker, former client, etc) and if they are a broker which client they are a broker for (using the contact code in a look up list). I have a second table that contains the client name, account name(s) and number(s). End result is I need to do a mail merge using the broker info (name, address, etc) and the client account name(s) and number(s).
What would be the best way to link the two tables (or create a relationship between) the two tables so that a query will pull up the broker info and the related client info?
The forum won't let you upload .mdb or .accdb files because of the potential of spreading malicious code. One method to exchange the files is zipping the file (as Boyd suggested). If you don't actually require the compression you can just change the extension to something benign like .txt. Given you guys are struggling, and I assume this is a teeny file, mebbe this could be something to try.