This set entered on 5-20-14 5.17.14.1
1. p 365. RELATIONSHIPS WITH TABLE OCCURRENCES. Before you can hook up TABLE OCCURRENCES, you’ve got to make sure that:
BOTH TABLES have the PROPER KEY FIELD for the new relationship.
- I added a new KEY FIELD to a table, but the table already has lots of records. Since my SERIAL NUMBERS ARE CREATED ONLY WHEN I CREATE NEW RECORDS, how do I enter data into this new KEY FIELD for all the existing records?
a. Create a new field with AUTO ENTER SERIAL NUMBER option
b. Put it on a table that’s tied to one of that table’s TABLE OCCURRENCES
c. RECORDS–>SHOW ALL RECORDS
d. Click in your NEW FIELD AND: RECORDS–>REPLACE FIELD CONTENTS
e. Select the REPLACE WITH SERIAL NUMBERS option
f. Select UPDATE SERIAL NUMBER IN ENTRY OPTIONS? and click ok.
g. NOW you turn on Prohibit Modification of Value During Data Entry.
- You need to form a RELATIONSHIP between the EXPENSES TABLE and the LINE ITEMS table. Create a new field in the EXPENSES TABLE and call it LINE ITEM ID, You’ll use this field to:
RELATE THE EXPENSES TABLE to LINE ITEMS.
- Why do you need to create a NEW relationship between EXPENSES and LINE ITEMS?
so you can have a direct relationship between those two tables without going TROUGH the JOBS and INVOICES table.
- Since you want to access LINE ITEM details while you’re on the EXPENSES layout, you’ll:
CREATE A NEW TABLE OCCURRENCE for the LINE ITEMS TABLE.
- In GENERAL, which table gets the NEW TABLE OCCURRENCE?
In GENERAL, it is the information that you’re using in a NEW WAY (the LINE ITEMS data, in this case) that gets the new table occurrence.
- Once you KNOW you need a new TABLE OCCURRENCE, how do you decide which of the TWO TABLES involved needs the NEW TABLE OCCURRENCE?
To decide, you need to ask yourself this question: WHICH TABLE HAS THE INFORMATION I NEED?
- How do you name a NEW TO? It does not keep the name of the ORIGINAL TABLE (ORIGINAL TABLE OCCURRENCE):
If you create a new occurrence of the LINE ITEMS TABLE so you can access information from it from the EXPENSE TABLE, then the name would be: Expenses__LINE ITEMS.
- How EXACTLY do you write the name for a new TABLE OCCURRENCE?
Expenses__LINE ITEMS. The table used to access information is in LOWER CASE, the table FROM WHICH INFORMATION is being accessed is in ALL CAPS. There is a lower line separating the two names.
