Access database- Need help setting up?

Question

I am setting up an access database to track manufacturing orders and raw materials. What kind of tables should i set up. And what kind of relationships?

For each manufacturing campaign there will be several raw materials. And each raw material has to be tested and released. I'm thinking there should be three tables.

One for each manufacturing campaign (mfg date, customer, work order number etc)

One for each raw material (raw material name and ID number)

One for the testing of each raw material (Raw material name/ID, date sampled, status of testing etc)

Can you help me get started?

Answer 1

I think your manufacturing campaign table should have a customerID field that links to a 4th table for Customers--I'm assuming you keep more customer info than just their name.

One raw material is tested many times--each time you get a new supply of material--so that's a one to many relationship.

Does one campaign use more than one raw material? If so that's also a one to many relationship.

Aside from that it looks like you're on track with the rest of it.

Hope that helps

Answer 2

Relationships are from the detail table to the element in the master table that corresponds. Start with looking at the company reports to find out what data is needed for reports, and organize the information logically.