"Steve" wrote in message
...

Primary and foreign key fields all end in "ID". Primary keys should be
autonumber and foreign keys should be Number - Long Integer. The primary
key of each table is the first field under the table name. All other "ID"
fields in each table are foreign keys and have the same name as their
related primary key. So to set up the relationships connect all foreign
keys to their appropriate primary key. Let me know if you don't
understand.

Steve

subtle stevie. Let "me" now... These newsgroups are not your private domain
for hunting victims. There are far more qualified people hear who will help

John... Visio MVP