Thanks for the response Ponderworks. The certified members or non-members can have more than 1 certification. So it should be a one-to-many. The members have a member id. The certified members are only identified by their names and addresses. SS #'s are not required, so I can't even use that...
I need a suggestion on the best primary key to use. Here is the situation:
I work for a company that has a membership base and a certification base. People can be mixed from either database. Members can be certified but certified people don't have to be members. The issue is that we are...
I am so totally stuck. Using autonumber as a primary key how do I create a relation to other tables? Do I make a field with type "Number" and an integer and just assume that the number will have to be typed?
X-)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.