The Coffee database challenge
You are going to use the knowledge and skills you have learned in class to construct a data base - invoice system for a coffee company.

This data base will be almost identical in setup to your Baseball project. It will have an Invoice table, a customer table, and a products table. The good news is that these tables and data have been already typed in.

The challenge is that the line item table is not created and there are no relationships or value lists made yet.

The file you need to start is called: invoice-coffee.fp7 . It is located on the top level of your hard disk -copy it into your docs folder.

Below is a screen snapshot of the completed relational DB..

CLICK ON THE IMAGE FOR A BLOWUP
Instructions: This is a LAB, do as much as possible on your own.

1. Complete the Customer Information section of the Invoice table.
a. relate the Invoice to the customers.
b. place related fields on the Invoice

2. Create the lineitem table and create two fields to act as foreign keys.

3. Relate lineitem to products.
a.create lookups for price and product name.
b.create quantity and extended price flds.

4. Relate invoice to lineitem.
a. create portal on Invoice
b. make portal Product Number field a popup that has the number and coffee name.
c. create a field under the portal that calculated a grand total of the extended prices.

Click here to see relationship diagram5