I have a database in which I am trying to set up a form and a subform (the forms are already created). I am trying to create a one-to-many link between the tables but all I get is a one-to-one. I have read the "help " but I am still stuck at square one. Can anyone help me? Thanks for any input.

The problem is most likely with your table structure. Can you advise on specifics including relationships of the two tables that will supply data to form and subform?

Thanks for replying.

I have managed to apply an index to the relevant field which means I now have the one-to-many relationship needed to make the form run. Fingers crossed it keeps going!

Many thanks for taking the time to answer.