I am working on a database to track links between people, places and organisations.
Form 1 is object which has one field - name
Form 2 is link which has two fields I want to relate to two objects.
An object can have MANY links. So I'm trying to make a ONE to MANY to ONE relationship.
I want to be able to create links from either an object form or a link form.
I want to be able to show reports (lists) of links
I want object reports to also show the list of links they have
so:
I have set up the object form. This has a subform for links.
I have set up the links form with two lookups for object.
I can add links from the object form's subform.
But when I create them from the links form the relationship is lost.
Any ideas?