linking with multiple field ID's

[Guest]

Hello, I am an absolute newbie with access so my apologies if my question is
not clear, or badly formulated.

I am a biologist and want to have a database for butterflies with
information about which countries they occur in. I have a table with a field
of butterfly species, a table with a field of countries and a table with two
fields linking butterfly species and countries.

I would like to have a form that allow me to view and alter the linked
countries per butterfly species. Note that one butterfly species can be
linked to one or several countries, but I want an overview (as a list) of all
these countries in the form, with the option to add or remove countries. I
hope that anyone can advise me on how to achieve this. Thank you!

 

[Carl Rapson]

Hello, I am an absolute newbie with access so my apologies if my question
is
not clear, or badly formulated.

I am a biologist and want to have a database for butterflies with
information about which countries they occur in. I have a table with a
field
of butterfly species, a table with a field of countries and a table with
two
fields linking butterfly species and countries.

I would like to have a form that allow me to view and alter the linked
countries per butterfly species. Note that one butterfly species can be
linked to one or several countries, but I want an overview (as a list) of
all
these countries in the form, with the option to add or remove countries. I
hope that anyone can advise me on how to achieve this. Thank you!

Create a form based on the butterflies table. Create another form based on
the junction table (butterflies and countries), set its Default View
property to Continuous forms, and add this second form to the first as a
subform (just drag the second form to a blank spot on the first form and
drop it). In the Link Master Field and Link Child Field properties, specify
the butterfly. Now, when you open the butterflies form and navigate to a
particular record, the subform should show all records from the junction
table corresponding to the current butterfly. You can also add additional
countries in the subform and they will be stored automatically.

Carl Rapson