tblScrapTickets:
ScrapTicketID, AutoNumber, Primary Key
ScrapTicketActivityType (linked to an ActivityType table)
ScrapTicketDate
ScrapTicketShiftNum
tblParts
PartID, PK, AutoNumber
PartName
tblScrappedPart (Junction Table):
ScrappedPartID, AutoNumber, Primary Key
ScrapTicketID, FK (Lookup to tblScrapTicket)
PartID, FK (lookup to tblParts)
ScrappedPartDate
ScrappedPartQuant
ScrappedPartReason (linked to a ScrapReason table)
The above tables represents my effort to do the following:
I have a scrap ticket. That scrap ticket hass static and dynamic data. The static data is the date, shift, type of activity. I also need to assign a number to the scrap ticket to be able to look one up later.
The dynamic data is that there can multiple parts, quantity, and reasons on a ticket and I would like to tie those records back to the static ticket number all on a single form. If my tables are correct how do I get to the next part: the form?
Start Free Trial
