display multiple record in one row

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Answered in your repost of 8 hours later.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Daniel P said:
Hello,

I have a form whose record source is a qry consisting of two tables. The
Click to expand...
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
Click to expand...
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
Click to expand...
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?
 
Back
Top