Help with linking tables

[shubanacadie]

Hey,

Sorry if this is a really basic question for you!

I posted this onto the Excel section but was advised that Access would be better to do this. As I have now used Access for all of......... 2 days...... ideas on how to/ ways to set this up etc would be fantastic.

Basically I have 3 tables all of which have the exact same layout etc;

Quotes A
Quotes B
Master Data

Idea is that;

Person A can enter any quotes they do onto their table (Quotes A)
Person B can enter any quotes they do into their table (Quotes B)
This information entered then automatically updates in a continuous list into 'Master Data' table

Person A and Person B have their own file so that 'Master Data' cannot be changed by them and will only be able to be amended by the 'Master Person'

So, For example

On Monday Person A enters the quote information all the way along until relevant fields are filled in. Then it automatically goes nicely into the Master Data row 1
On Tuesday Person B then fills in his quote information all the way along until relevant fields are filled in. Then it automatically goes nicely into the Master Data row 2

So the Master Data table is continually updating from the other 2 tables

So questions are;

Is it possible to have a list that fills in nicely underneath each other in the master table?
What is the best way of setting this out?

Eventally we want to add other information like customers, suppliers etc but this part of the set up is key for us at this stage.

Any help/ comments appreciated!

Many thanks in advance

[Babilv]

I am not sure what your question is...can you clarify a bit more, perhaps provide an example for this statement: Is it possible to have a list that fills in nicely underneath each other in the master table

[shubanacadie]

All we need it to do is fill into a Master Data table from 2 other table locations.

For example Person A enters the quote information in his table - this then gets automatically input into the Master Data table row 1. Person B then fills in his quote information in his table. That then automatically gets input into the Master Data table row 2 - so on and so forth.

I think that we will get software written for us as I dont think that we will be able to achieve what we want with either Excel or Access.