Jump to content
Sign in to follow this  

Having trouble relating 3 value lists to eachother...

Recommended Posts

Hi there

My apologies for repeating this question for the xth time, but I've read most of the threads relating to this problem and have tried to implement proposed solutions, without much success.

I have 4 tables:

1 - Families, providing a list of families

2 - Genera, providing a list of genera linked to a family

3 - Species, providing a list of species linked to a genus (Genera)

4 - DNK, showing a sample identification record with additional information about each sample.

Should be able to create new genera linked to existing families and new species linked to existing genera.

In table DNK, needs to show the Genera for the selected Family, and then the Species for the selected genus.

I'm attaching a reduced version of the database for demonstration. Have NOOOOOOOOOO idea what I'm doing wrong anymore. Can anyone be of assistance?

P.S. If a login screen is produced, just type admin and leave password empty. For testing, only use families Terebridae or Conidae as no other Genera have been created.


Share this post

Link to post
Share on other sites

Relationships have to have the same type of field on both sides.

Try this...

BTW: G. Raybaudi Massilia is my sister.

( Conus biraghii, bondarevi, jeanmartini, korni, lizarum ...)


Share this post

Link to post
Share on other sites

Hi Daniele

This is sooooo embarrassing : , such a beginner's mistake and I didn't even catch the error myself. You'd think this is my first database...

Thank you for pointing out the obvious to me! :


P.S. I was already wondering about the name... :

Share this post

Link to post
Share on other sites

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.

Reply to this topic...

×   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.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.