I have two basic tables I am trying to link.
personID - auto number - unique
motherID - number
faterID - number
id - auto number - unique
date - date
type - text
personID - number
I'm trying to do a one to many relation ship between the person ID in tableA to tableB. When I try to make the link and select the personID it won't show me perosn ID as an option. What am I missing?
I've been using access for a while, and was looking for an alternative, so maybe I'm thinking about this because that's what I'm used to.