In Access (Office XP) I want to be able to have seperate tables with information which I will call tables, A, B, C, D. Then I will have a master table that combines all the records into one table called ALL. I can do this allright, but my main goal is to be able to enter a record into table A, then have that record show up in the ALL table automatically without having to copy and paste it. Is there any way I am able to do this? I thought relationships would be able to, but it didnt work or I did not do it right.

I've done similar things with macros. For instance, using the On Update event, you can have it copied to the All table automatically whenever a field is changed.

Typically though, the information only needs to be in one table. Through the relationships, the info can be manipulated to display on the forms and reports.

I tried playing around with it, but still no luck. Im thinking about having just one master table, then having queries for each seperat categorie that i have my contacts in, which is seven categories. But im still unsure if it will let me input the info like i want it to. Im not to familiar with macros either, so that was a problem for me.

Got it, worked out fine. And using a Form is the easiest way and sorts and inputs everything for me into the tables and queries automatically, just as long as the group title is inputted, and the query is sorted by that field and that field only.