>All the advice you are getting is correct. Every table should have a meaningless, unique primary key value. Add a primary key value to the detail table. We have had many discussions here on the UT about whether the PK should be a combination of other columns or a system generated value. I prefer to use a system generated integer for stand alone systems and GUIDs for systems that aggregate data from other systems.
>
>Also, I avoid the use of underscores (_) in table names and column names. They do not really make the names more readable and add extra keystrokes. Also, if using free tables, it allows fewer characters in the column name. So inv_no becomes either InvNo or invNo. inv_date becomes either InvDate or invDate.
>
Good suggestions.
If it's not broken, fix it until it is.
My Blog