Repost: display multiple record in one row (with more explanation)

[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 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?

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

Issue MSN
***********************************
A 0005, 0007
B 0008

What I would like to know specifically is how can I create an array 1xX in length that will contain all the MSNs for each drawing issue? How would I build such a control source?

If you need more info, please let me know, I really need a hand with this one!

Thanks

Dan

 

[Adrian Jansen]

Just make a subform on the main form to display the MSN numbers and details.

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

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

Issue MSN
***********************************
A 0005, 0007
B 0008

What I would like to know specifically is how can I create an array 1xX in

length that will contain all the MSNs for each drawing issue? How would I
build such a control source?

 

[Dirk Goldgar]

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?

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

Issue MSN
***********************************
A 0005, 0007
B 0008

What I would like to know specifically is how can I create an array
1xX in length that will contain all the MSNs for each drawing issue?
How would I build such a control source?

If you need more info, please let me know, I really need a hand with
this one!

Thanks

Dan

If you want this list for display purposes only, it sounds like you
could use the fConcatChild() function posted here:

http://www.mvps.org/access/modules/mdl0004.htm

Having placed the function in a standard module, you could put a
calculated text box on your form with this ControlSource expression:

=fConcatChild("tblMSNs", "DrawingID", "MSN", "Long", [DrawingID])

(where "tblMSNs" is the name of the second table you mentioned, which
contains the MSN field).

 

[Dirk Goldgar]

Dirk,

I can't seem to get the function to work properly. Is there any
insight you can give me to get it to function?

Not unless you show me how you're calling it, and tell me what you mean
when you say it doesn't "work properly".