One-To-Many Grid Form

[joe]

With a One-To-Many relation between two tables, is there a way to
display the fields of the "One" table once in a "grid" like display?
See below. I'm using Access 2002, but have 2007 if it has any new features.

Company.... Name
AAA John Smith
Bill Smith
Jill Jones
BBB Joe Blow
Harry Smith

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Albert D. Kallal]

No, but you can use two sub forms side by side..

Take a look here for some ideas:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

the "last" screen in the above is what I tend to use/do in these types of
cases....