Table creation help!!

[maGemme]

Hi guys,

I have a problem which might be eay to fix but I can't figure out how to do it. I've searched google and the forums but can't find the exact wording.

I have a main table which holds different companies and their demographic information. Periodically, these companies will send me water analysis which I want to enter in a database, linked to the companies.

In each analysis I have about 20 samples (rows) and each sample has about 5 components being analysed (columns). Now this is easy to do in a table and is not my problem.

My problem is that I'll receive over 200 of these analysises every year so I can't use the same table. In Excel I'd probably create a different spreadsheet for each company and have a sheet for each analysis.

What do you suggest I do with Access?

I was thinking of creating a new table for every analysis but I'd end up with over 200 tables every year...

 

[Mr. B]

I would assume that you have a record ID value as a Primary Key for each entry for companies in your main table. All you would need to do is create a new table with its own record ID field as a Primary Key, a Number (long integer) type field that will serve as a Foreign Key field (linking to one company record in your main table) and then any other fields you need to store the data for each water analysis record.

Using the method, you can store as many water analysis records in this table as necessary and have each record linked to a specific company record in the main table.

 

[maGemme]

Ok, I think I understand. I'll get back to you if I have further problems!

THANK YOU!