Can I add records form a table and related records another table to a third table?

Can I add records form a table and related records another table to a third table?

Post by colm.ohaga » Sun, 04 Apr 2004 11:37:38


Hi there,

I having a problem with a database I'm setting up, I would be
delighted if someone out there could help.

The database I'm setting up is a task register datebase, it will be
used to create work schedules for workers in a metal work shop, based
on the tasks required to make a part and the tasks required to make
the subcomponents of the part.

In the DB I have three main tables; the first table is called Parts
with a related table called SubComponents the third table is called
Tasks. I want to be able to select a record from the Parts table and
add it and its related records from the SubComponents table to the
Tasks table. The desired result is to have a list of all tasks that
need to be completed to make the required parts and their sub
components.

Could anyone advise me on how to achieve this?

Thank you in advance,

Colm
 
 
 

Can I add records form a table and related records another table to a third table?

Post by colm.ohaga » Thu, 08 Apr 2004 11:44:36

i Salad,

Thanks for the help. I putting it into action now.

I have one more related question.

I have a form with a subform. On the form I have a text box
'NoOfParts' I want to press a button and have the value entered in
this text box 'NoOfParts' to be copied to another text box in the
subform. If you could help me with the code for this I would be
delighted.

Thanks again,

Colm


Salad < XXXX@XXXXX.COM > wrote in message news:<D4tbc.13718$ XXXX@XXXXX.COM >...