View Full Version : Displaying 1 to many relationship DATA


wotamelon
08-18-2010, 03:53 PM
Is there a way to adjust properties setting on a text box so that it will display more information?

This is a one to many relationship.

So for instances... On the report i have one customer (TOM) owning 2 CARS.
On the TagNo. or Reg.No text box it will only show up the first CAR, but no info on the second CAR. Is there a way to excecute it without doing subforms?

AccessBlaster
08-18-2010, 04:31 PM
it will only show up the first CAR, but no info on the second CAR.
That is the point of the subform to show the "Many". The main form shows the "one", and the subform shows the many [cars] in your case.

wotamelon
08-18-2010, 04:58 PM
im glad that clear things up!! thx

AccessBlaster
08-18-2010, 05:38 PM
My answer was very simplistic but, I am glad you got the message.