Re: naming conventions

Matthew, The convention I use goes as follows: [ I am doing this without testing as I go so if something is wrong, don't sue me :P ] Lets say I have two tables... PEOPLE people_id (primary key) people_namefirst people_namelast people_namemiddle people_age place_id (foreign key) PLACE place_id (primary key) place_name place_address place_numberphone place_numberfax What I do is use [tablename]_[fieldname]. This convention makes SELECT statements like this easy... SELECT people.people_id, people.people_namefirst, place.place_id, place.place_address FROM people, place WHERE people.place_id = place.place_id AND place.place_name = 'IBM'; Otherwise, it would be difficult to differenciate between place_id (the foreign key for the PEOPLE table) and place_id (the primary key for the PLACE table). -Jeremy Email: jer2475@home.com