Microsoft Access Help
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.