Hello,
Apologies is this is fairly basic or if the answer has already been posted elsewhere. I'm new to this!
I have a database with two tables: Organisations and People. An organisation can comprise of many people and the people can also be members of more than one organisation. To show these links I created a third table which contains the OrgID and PeopleID. I then defined the relationships between the three tables to create a many to many link between Orgs and People.
After that I created a main Organisation form. I then created a query which included the IDs from the Link table and the fields from the People Table. I created a subform from the query and insert it into the main organisations form. I could then link the organisations to people by changing the person name into a combo field, row source to the person ID etc.
This all worked fine if I had people that were already created and I wanted to link them to the organisation.
However, I would like to be able to create new people records from the organisation subform, thereby directly linking the two. I just can't figure out how to do this last bit.
Any help would be appreciated!