How to connect one field between different records?
I am building a database.
Database is the following:
i have 2 sets of people, the volunteers (who guide the childeren), and the childeren themselves.
We create groups of 10 childeren and 2 volunteers.
I want to be able to see, when i am looking at a record of a kid or a volunteer, in which group they belong.
Also i want to be able to change this on the fly
and i want to see on the volunteer side which childeren they have under their "command".
and i wnat to see when i'm looking to a kids record, to which volunteer they belong.
Can someone give me a short explenation of what to do?