Sales Form Question longish but important (for me)

[Veli Izzet]

Hi all,

I have a Sales form with salesDetails subform (Also Sales table and
Sales Details Table)

Sales Table
-----------
SalesID
CustomerID
ShippingAdress
SalesType (Important because sales may be final or on consignment)
etc.etc.

SalesDetails Table
------------------
SalesID
ProductID
UnitPrice
Quantity
Consignment (For Flagging Yes/No)

Products Table
--------------
ProductID
Location (In which Warehouse- The products on consignment basis are also
tracked here
etc.etc.

Problem:

1- When the sales are final, there is no problem.
2- When the sales are in consignment basis, it is shown on the main form.

I want to be able to to pass that information to the subform, and flag
the consignment field of the SalesDetails as "Yes"

3- When the sales are in Consignment basis, I would like to change the
Location field of the Products to the Adress shown on the Sales form.

Can it be done?

Thanks for answers.