One-To-Many Grid Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joe - 12 Apr 2008 17:26 GMT

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

Reply to this Message

Peter Hibbs - 12 Apr 2008 21:49 GMT

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

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20D
emo.mdb'

for some examples.

Peter Hibbs.

>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?
[quoted text clipped - 6 lines]
>BBB Joe Blow
> Harry Smith

Reply to this Message

Albert D. Kallal - 13 Apr 2008 01:58 GMT

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....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message