Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Having trouble relating 3 value lists to eachother...

aislinn
in Value Lists

Featured Replies

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.

DNK_Copy.fp7.zip

text with text !

  • Author

Sorry, you have to be a bit more clear... I'm not sure I understand what you mean.

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

DNK_2.zip

  • Author

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! :

Isabelle

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

Create an account or sign in to comment

https://fmforums.com/topic/60177-having-trouble-relating-3-value-lists-to-eachother/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.