Simple question i'm sure

[lili429]

I have spent so much time putting together a database of information that has come to me from so many different places - and now my brain is just stuck.

I have one table where I forgot to insert the email field and I have queried it and sorted it... etc.

I want to pull the information from another table I have - BUT - only for the records that match the records in the first table.

Can someone just quickly help?

 

[jdraw]

I think you may get some ideas from this article
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

 

[lili429]

I'm sorry I just don't understand the lingo.

 

[jdraw]

Did you go through the example from start to finish? He does everything in steps.

 

[Big Pat]

There's a lot of stuff in that document and it's hard to take it all in, especially if you're self-taught like me and have some gaps in your knowledge and maybe some bad habits.

If I understand correctly, you have two tables, one containing records of people of some kind and another containing email addresses. The 2nd table should have a field that relates back to the first. Let's say table1 is "Customers". You'll have CustomerNo, CustomerName, CustomerPhone, etc. Let's say table2 is "Emails". You (should) have a field called CustomerNo in that table too.

To design your query, add both tables to the design grid. Drag the CustomerNo field from Customers across to Emails. This creates a join. Now double click the fields you want from each table to put them in the grid and when you run the query you will see the email addresses. But only where email addresses exist!!

If you want to see ALL the Customers, with blank spaces where no email addresses exist, then double-click the join line and change it from '1' to '2'.