Base form for joins table advice

Hello all!

First time posting here so I apologize in advance for any etiquette breach.

I have a simple Base project that I’d like some advice on how to approach providing a form for users.
The data model is relatively simple with a survey table, species table, and a joins table to hold all of the species identified during a survey:

The joins table has FK to the survey id and species id.

I’d like to create a form in base where the user can fill out data for a given survey, and then add multiple entries to correspond to each species they found. (The joins table will also have a count column, not shown in the above diagram).

Ideally the form would have inputs for a particular survey, but then I’d like to allow them to add any number of species (and a count) as well.

Any advice on how to proceed with something like this? TIA!

https://forum.openoffice.org/en/forum/download/file.php?id=11250

1 Like

Ah, excellent! Thank you for the example!

For future people, the link was to this file:
relations2listboxes.odb (61.1 KB)