Subform mayhem!

[Rothron]

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.

 

[chrismcbride]

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?

 

[Rothron]

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.