Originally posted by sorex what's the use of the diagram anyway?
when i reopen the things i did yesterday i see the relations but they dissapear when the table content appears.
so it's a waste of time to use this feature or not?
The major purpose of the Diagram Editor is providing a visual tool to identify referential integrity within your database. It is the exact same tool as "Relationships" in Access. Yes, you can identify FK constraints by using the "Manage Index" tool for each table, however, I find the Diagram Editor to be quite useful and easy to establish FK constraints and show referential integrity between tables within my database systems.
The major problem with what you have done so far is within your database schema design. When I said that you should have primary key IDs in your tables, I meant that you needed to specify a current column within the tables and make that the PK, not necessary adding another field. Also, your columns are not normalized across the two tables.
Why do you have duplicate Company and contact information columns within each table?
What is the purpose of the abbrev and company tables? How are they supposed to relate to one another?