FM Pro Relational Data Base
“The baseball card dealer”
These instructions assume you have looked at the data base flow chart below.

1. Create the “Baseball Invoice” data base (master table)
make 2 fields
account # (foreign key-text)
invoice # (primary key-auto enter serial)

2. Create a table called "baseball cards".
A.The Table should have 6 fields
1. player name
2. year
3. card condition
4. card brand
5. value
6. card ID # (primary key)
B. Fill in the data for 10 fake cards

3. Create a second table called "Customers"
(this data base will be connected or related to the invoice data base)
A. The table should have the following fields.
1.last name
2. first name
3. street
4. city
5. state
6. zip
7. phone
8. account # (primary key)
B. Fill in the data for 5 fake people from around the country.

4. Create the “Line item” table
create 2 fields for use as match fields (foreign keys)
invoice id.
card id.
Relationships

1. Define the relationship between the invoice table and customers table.

2. Define the relationship between line item and baseball card tables.

3. Create the lookup fields that bring data from the baseball cards table to the line item table. (test the lookups)

4. Define a relationship between the invoice table and line items.

5. Create the portal on the invoice that grabs data from the line item table. (test)