Database Reference
In-Depth Information
graph. So take out your ER diagram and start by arranging the tables on the Relationships
graph like the tables on your ER diagram. Refer to
Figure 5-8
if you need a refresher. Once
they're in place, it's a breeze to drag key fields from table to table. Here's a list of the rela-
tionships you need to create:
▪ Customers::Customer ID to Jobs::Customer ID
▪ Expenses::Job ID to Jobs::Job ID
▪ Invoices::Job ID to Jobs::Job ID
▪ Line Items::Invoice ID to Invoices::Invoice ID
▪ Invoice Payments::Invoice ID to Invoices::Invoice ID
▪ Invoice Payments::Payment ID to Payments::Payment ID
▪ Timeslips::Job ID to Jobs::Job ID
Remember, it doesn't matter whether you drag from Customers to Jobs (for example) or vice
versa. What does matter is that you pick the right key fields to relate. When you're done, you
should have seven relationships lines and your graph should look something like
Fig-
ure 5-13
.
