I have a database that I am using to track submittals on construction projects.
I am struggling with how to handle resubmittals.
If the submittal is not accepted, there would need to be a resubmittal related to the original.
Attached is a shot of the relationships. The Status field is what I use to record if the submittal is "Approved" or "Rejected".
How would I link a new submittal to a rejected one from the same table?
I am struggling with how to handle resubmittals.
If the submittal is not accepted, there would need to be a resubmittal related to the original.
Attached is a shot of the relationships. The Status field is what I use to record if the submittal is "Approved" or "Rejected".
How would I link a new submittal to a rejected one from the same table?