Adobe
GoLive 6 Dynamic Content Samples
Overview
Database Design
Phone Directory
Edit Phone Directory
Confirm Deletion

text

There is a single table to keep track of employee names and phone numbers.

People

Each employee has a first name, a last name, a phone number, and a unique ID. This design uses an autonumber field for the employee ID, so that the database automatically assigns a new number to a new employee. A more complete design might use preexisting employee ID's, or keep track of more information like an employee's office number and manager.

Not all databases support autonumber fields. If yours does not, you can always use a user supplied numeric field instead. You just need to add an additional text field to your Administration View pages so you can edit the field.