Thanks, it's good to be here! :-)
Thank you for your reply. So you're saying that Autonumber and number can be linked on the relationship table? Can I enforced Referential Integrity? I thought two fields in a primary/foreign key pair had to be of exactly the same type.
I'm still building the...