Hi, i run into some problems with the design of a db.
In the attachment you can see the db.
I need to connect tblAddendumDetails to tblAdvanceInvoices and tblFinalInvoices, but i get a referential integrity error.
Can't tblAdvanceInvoices and tblFinalInvoices be used by both tblContracts and tblAddendumDetails ?
Is there anyway to make this work or i need to create 4 more Invoices tables for the Addendums ?
Is an addendum invoice the same thing as a contract invoice? If not, you should create separate tables. Have a look at this article, particularily the section on normalization. To have good database design, you need to make sure all fields in a table are dependent upon the primary key. Linking your addendum details table to your advanced invoices and final invoices table would violate this principal.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks