joop123456
asked on
Copying a number to a table when adding new record - 2
Hi!
How will the VBA be with one table extra in between? But now from discount >> discount2
(the question, when adding a new related record to tblL2, I want the latest "discount" to be copied to "discount2" in an access form.)
qryZagerijen_REL_be
-ZagerijID (unique record)
-Discount
tblL1
-ContractAUTOID (unique record)
-ZagerijIDContract (one-to-many relation with unique field "ZagerijID" from "qryZagerijen_REL_be")
tblL2
-tbl2AUTO (unique record)
-ContractAUTOID_TL2 (one-to-many relation with unique field "ContractAUTOID" from "tblL")
-discount2
All records mentioned will be in the form's record source.
When making a query of the 3 tables it looks like this:
SELECT qryZagerijen_REL_be.Discou
FROM (qryZagerijen_REL_be INNER JOIN tblL1 ON qryZagerijen_REL_be.Zageri
How will the VBA be with one table extra in between? But now from discount >> discount2
(the question, when adding a new related record to tblL2, I want the latest "discount" to be copied to "discount2" in an access form.)
qryZagerijen_REL_be
-ZagerijID (unique record)
-Discount
tblL1
-ContractAUTOID (unique record)
-ZagerijIDContract (one-to-many relation with unique field "ZagerijID" from "qryZagerijen_REL_be")
tblL2
-tbl2AUTO (unique record)
-ContractAUTOID_TL2 (one-to-many relation with unique field "ContractAUTOID" from "tblL")
-discount2
All records mentioned will be in the form's record source.
When making a query of the 3 tables it looks like this:
SELECT qryZagerijen_REL_be.Discou
FROM (qryZagerijen_REL_be INNER JOIN tblL1 ON qryZagerijen_REL_be.Zageri
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Forgot to mention, I noticed in the main-posting that I posted a similar question a while ago:
https://www.experts-exchange.com/questions/22895990/Copying-a-number-to-a-table-when-adding-new-record.html
Maybe helpfull...
Rgrds, Joop
https://www.experts-exchange.com/questions/22895990/Copying-a-number-to-a-table-when-adding-new-record.html
Maybe helpfull...
Rgrds, Joop
ASKER
Yes, every ZagerijID (=Supplier) has only one - latest - discount percentage. Since it is changing
sometimes and when I enter an order, I want to work further in this order (tblL1 and tblL2) always
with the latest discount percentage available at that time.
In case this unique discount-% is changing, the discount2 fields shouldn't be updated. Only updated
(>copied) when adding a new record in tblL2.
(Percentages in a certain period stick should together with orders from that period, new orders might have new %-rates)