When PageGate creates a new record in any of its tables, it will never leave any field with a NULL value. Many database environments (like MS Access, and MS SQL) will leave any unassigned text fields as NULL. These fields should always be initialized to a zero length string (i.ie ""), never left as NULL.

And the second table
Table Name: Escalation
Feild 1: Escalation; The name of the person
Feild 2: WorkN ; The persons work number
Feild 3: PagerN ; The persons pager number
Feild 4: DispatchN ; The pagers dispatch number
Feild 5: DMail ; The persons emaile is

Now I need to create a users table which will get the name, and page number from these tables.