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.