Lots of Help Needed!

[kennuge]

I am trying to build a database where I am tracking corrective action requests to a supplier. I've got 3 tables set up. One is for the general information about the problem that has occurred. The next one is a table that only contains a couple of dates with the initial response from the supplier and comments that my company would make (if needed). The last table will include all of the defect root cause investigation and actions they will take.



There will be an action number associated with each concern. I've set that up in the first table using a calculated field. I want that number to auto-populate into the other two tables based on whether or not there is a need to have a response (I have a logical field setup in the first table to click the box if a response is required). I don't have a clue where to begin.

I'm very much a novice at building Access database's, but what better way to learn. I could always build one huge table, but I thought that a few small tables might be more efficient.

Any suggestions would be greatly appreciated.

[ranman256]

You need 4 tables:

tSupplier table (all info on 1 supplier / record) with a [supplierID] as (autonum)
tRequests
tReponses
tDefects

tRequest
[ReqID] (autonum)
[supplierID] (umber)

tReponses
[respID] (autonum)
[ReqID] (number)



You can use the TABLE WIZARD to help you pick and choose fields for what you want.
Try that.

[ssanfu]

I agree with ranman - at least 4 tables. I came up with 6..... this is a first pass.

This is my take on the structure: (but what do I know )
Attachment 18786