query add to table from other table

I

informatique

Hello,

I've got the following pb and don't have any tutor to find the solution.
Sorry for this newbies question.


Here are simplified tables.

Table1 = Firm
idFirm
NameFirm

Table2= DeptFirm
idDeptFirm
NameDeptFirm
idFirm (with a relation 1->n from table 1 to table 2 field (idFirm))

Table 3 = Customers
idCustomers
NameCustomers

Table 4 = PriceListCustomers
idPLCustomers
idCustomers (with a relation 1->n from table 3 to table 4 field
(idCustomers))
idDeptFirm (with a relation 1-1 from table 2 to table 4 field
(idDeptFirm))
Price

I'd like to make the following query :

When I add a new firm in table 1 and his different dept in table 2
I' d like to add in the table 4 PricelistCustomers records for all the
client (idCustomers)
with reference to the new firm and new dept.

So we can specify in the Price field from the table PriceListCustomers an
pricelist
for the new dept of the new firm.

First sorry for my english, and for the following 'bad' explanations.
 
Top