Or maybe just bad practice. Thought before I go any further I'll ask. I have a few static tables that list out "items" and the primary key is an "assigned" ID. Meaning I did not set auto-increment. As I add items I will add the associated ID number.
Now to the transactional tables. While the label has the item listed in the form, it gets inserted into the table with the ID number. To illustrate: Static_Table ID Value 1 United 2 Jet Blue 3 Southwest 4 American Dynamic_Table MemberID Airline_Pref 200 1 201 4 202 3 203 4 204 1 Pros cons dangers advantages comments ? Thank you Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
