i am creating a small database with tables: bars, restaurants, clubs and hotels in a particular city. I have set an ID/autonumber to each entry in all tables. Although i dont want a number to duplicate in any of the tables. i set it to no duplication and the relationship is set AND STILL it does not work. can anyone help me?