Group:  Microsoft Access ยป microsoft.public.access.dataaccess.pages
Thread: parent and child table on DAP

parent and child table on DAP
Souris 1/14/2006 7:22:01 AM
I would like to know that is it possible to have parent chile table on the DAP.

For example, I have customer and order table.
I need to show cusotmer and detail order for customer number 1.
I tried to connect my table, but one parent or child table can on the form.

Any suggestions are great appreciated,
Re: parent and child table on DAP
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 1/18/2006 6:55:42 AM
You can create a subform on the DAP page. If I remember correctly, you can
do this by opening the Fields List window and dragging the secondary key
onto the page. If you drag it at the right place, Access should ask you the
question if you want to add a subform. Move around until you find the right
place.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Souris" <Souris[ at ]discussions.microsoft.com> wrote in message
news:DF666C51-755D-48AF-AFD1-D9693762EF7C[ at ]microsoft.com...
[Quoted Text]
>I would like to know that is it possible to have parent chile table on the
>DAP.
>
> For example, I have customer and order table.
> I need to show cusotmer and detail order for customer number 1.
> I tried to connect my table, but one parent or child table can on the
> form.
>
> Any suggestions are great appreciated,


Re: parent and child table on DAP
"urtu565" <655u> 3/30/2008 3:32:52 AM

Souris <Souris[ at ]discussions.microsoft.com> wrote in message
news:DF666C51-755D-48AF-AFD1-D9693762EF7C[ at ]microsoft.com...
[Quoted Text]
> I would like to know that is it possible to have parent chile table on the
DAP.
>
> For example, I have customer and order table.
> I need to show cusotmer and detail order for customer number 1.
> I tried to connect my table, but one parent or child table can on the
form.
>
> Any suggestions are great appreciated,


Home | Search | Terms | Imprint
Newsgroups Reader