display multiple record in one row

[Guest]

Hello

I have a form whose record source is a qry consisting of two tables. The first contains a list of (shown below

Drawing ID Drawing Number Drawing Issu
*********************************
1 11111
2 11111
3 121346
4 2123456
...

The second contains a list of MSNs (as shown below ) has a 1 to many relationship with the fist tabl
ID Drawing ID MS
**************************
1 1 000
2 1 000
3 3 004
4 2 000
.....

My question is I have a form in which I has displaying a summary list of the drawing issues for a drawing number. However, I have been asked to now add a field which will list the various MSNs that are linked to each issue. How can I achieve this

Let say I'm looking at Drawing 11111 I would like my form to displa

Issue MS
**********************************
A 0005, 000
B 000

Thank you for the help in advance

Danie

 

[Adrian Jansen]

Answered in your repost of 8 hours later.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Hello,

I have a form whose record source is a qry consisting of two tables. The

first contains a list of (shown below)

Drawing ID Drawing Number Drawing Issue
**********************************
1 11111 A
2 11111 B
3 121346 A
4 2123456 A
...

The second contains a list of MSNs (as shown below ) has a 1 to many

relationship with the fist table

ID Drawing ID MSN
***************************
1 1 0007
2 1 0005
3 3 0045
4 2 0008
.....

My question is I have a form in which I has displaying a summary list of

the drawing issues for a drawing number. However, I have been asked to now
add a field which will list the various MSNs that are linked to each issue.
How can I achieve this?