spikepl
Eledittingent Beliped
- Local time
- Today, 11:54
- Joined
- Nov 3, 2010
- Messages
- 6,142
I would try this: make one table for all invoices
tblInvoices
-----------
InvoiceID (PK, autonumber)
InvoiceNumber (if you have some invoice naming rules)
InvoiceType (Advance/Final)
ContractID (FK from tblContracts, null if not refering to a contract) DuplicatesOK
AddendumID (or is it AddendumDetailID) (FK from tblAddenda or AddendaDetails, null if not refering to an Addendum) DuplicatesOK
other invoice data
and then kick out all references to invoices from all the other tables. As to only one invoice of each type for each "parent object" I would handle that in forms (in some code).
tblInvoices
-----------
InvoiceID (PK, autonumber)
InvoiceNumber (if you have some invoice naming rules)
InvoiceType (Advance/Final)
ContractID (FK from tblContracts, null if not refering to a contract) DuplicatesOK
AddendumID (or is it AddendumDetailID) (FK from tblAddenda or AddendaDetails, null if not refering to an Addendum) DuplicatesOK
other invoice data
and then kick out all references to invoices from all the other tables. As to only one invoice of each type for each "parent object" I would handle that in forms (in some code).