One to many display on form

[vgersghost]

I have a record in one table that has many records in another table and I would like to display them like this

Header of form
main record number (one to

the many)
Detail of form
Information one Information two Information three
Information four Information five Information six
Information seven and so forth.

Continuous form does not work, because the records jsut go down. Datasheet the same way. I have tried unbound controls, but cannot seem to get the date to flow into the boxes correctly.

Any help would be appreciated.

 

[KenHigg]

I think you need to do this with a main form / subform -

 

[vgersghost]

Subform

I have tried this with a subform and data still does not display across. Only down. On reports you can get this type of layout based on columns, but I cannot get columns to work on a form.

thank you for your idea

 

[KenHigg]

So in the detail how many fields do you have for each record and how many records will you have?

 

[vgersghost]

Information

Records in the thousands.

Example:

One tube might have 1200 combinations

I want to display tube and then all the combinations lay out like I showed.
If you even show 20 combinations down you have to scroll or page down 600 times. Searching works, but some case the tube could only have fifty combinations. That is why I would like the display to go across row by row with each being different


The one to many.

 

[KenHigg]

You may get something like post 7 in the following thread to wor:

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

I don't know of any other way to do this...

 

[Mike375]

Ken,

That thing in Post 7 is neat. I just stole it

Would be good for male merge for client and many policy benefits.

Hope Rich does not see it or he will think you have gone into spreadsheet mode

 

[KenHigg]

Thanks - I had to dream that up several years ago for a client doing a report...