Jump to content
  • 0

relationships don't seem to work



I have two basic tables I am trying to link.  

table A:
personID - auto number - unique
motherID - number
faterID - number

table B:
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.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...