Jon Albright
jon.albright at hawaii.rr.com
Sat Apr 12 22:12:12 CDT 2014
Hey Bill, Hopefully this isn't a duplicate post. Haven't been able to reply to your earlier message. So when creating the the cross tables, is it supposed to be a composite key between the two FK's of the related tables or can you have a primary key consisting of an autonumber field along with the two FK's ? Autonumber FK Number (long int) FK Autonumber PK Number (long int) FK Number (long int) FK I have seen examples of it used both ways and one states you must use a composite key? Of course you can't always believe everything read on the internet... Jon Albright Iniki Enterprises Honolulu, Hawaii (808) 677-7800 x116