Developing related Multi level child parent tables

brharrii

Registered User.
Local time
Yesterday, 22:58
Joined
May 15, 2012
Messages
272
I have created a table that acts as a header for my data and a second table that acts as line item data. What I need to do now is add a second child table that uses the line item data as its parent table and stores associated line items for each record. Is this possible? advisable?

This is a skeleton view of what I'm going for:

Master Table:
tlbAuditReportHeader
- AuditDate
- AuditArea
- Auditor

Sub Table:
tblDiscrepancy
- Discrepancy
- CorrectiveAction
- ActualCompletionDate
- VerifiedDate
- Notes

Sub table to Sub Table
tblFollowUp
- FollowUpDate
- AssignedTo
- SpokeWith
- EstimatedCompletionDate
- Notes

Sometimes tasks change hands or are pushed back depending on work load. It would be nice to be able to track something like this. This is what occurred to me as the best way to handle this, but maybe someone has other suggestions that could work as well.

thanks for your help
Bruce
 

Users who are viewing this thread

Back
Top Bottom