Box Seats

If you separate the forms from the data tables, you can work with the elephants on the workstation, and link to the tables on the server. This is one more step in Normalizing the database.

 

When you began with the table definitions, you separated like with like. Each table was a unique collection. The Movie table contains movie data, not customer phone numbers.

 

The goal is to create two databases that are linked together. One database will contain nothing but tables. This database will be placed on the Server.

 

The other database will have everything but the tables. This can be your user's application and it can run on their own hard drive.