P
PGray
Hi I'm new to this and trying very hard to teach myself. I have read a few
of the other threads and see that this support site really does work. I hope
someone can help me.
I have 3 tables and 3 matching forms- Subcontractor details, Subcontractor
Payments, Tax Verfication.
Subcontractor details holds all the normal data about the subcontractor with
a unique primary key of SubcontractorID
Subcontractor payments holds all the data about payments made to the
subcontractors with a multiple primary key of SubcontractorID and Payment
Date.
Tax Verficiation holds data provided to me by the Inland Revenue,
verification number, verification date, rate of tax to be deducted and the
Subcontractor ID. The primary key is the verification number. A
subcontractor can have more than one verification number.
The form for Subcontractor payments needs to get the latest rate of tax to be
deducted for the Subcontractor ID from the Tax verification table and use it
to calculate the amount of tax to be deducted. Once calculated the result
needs to be stored in the Subcontractor payments table. The rate of tax can
be changed by the Inland Revenue and therefore I need to store what has been
calculated.
I'm struggling to figure out how to extract the tax rate and how best to use
it in the calculation.
I hope I haven't waffled. Can someone help?
Regards
Paula
of the other threads and see that this support site really does work. I hope
someone can help me.
I have 3 tables and 3 matching forms- Subcontractor details, Subcontractor
Payments, Tax Verfication.
Subcontractor details holds all the normal data about the subcontractor with
a unique primary key of SubcontractorID
Subcontractor payments holds all the data about payments made to the
subcontractors with a multiple primary key of SubcontractorID and Payment
Date.
Tax Verficiation holds data provided to me by the Inland Revenue,
verification number, verification date, rate of tax to be deducted and the
Subcontractor ID. The primary key is the verification number. A
subcontractor can have more than one verification number.
The form for Subcontractor payments needs to get the latest rate of tax to be
deducted for the Subcontractor ID from the Tax verification table and use it
to calculate the amount of tax to be deducted. Once calculated the result
needs to be stored in the Subcontractor payments table. The rate of tax can
be changed by the Inland Revenue and therefore I need to store what has been
calculated.
I'm struggling to figure out how to extract the tax rate and how best to use
it in the calculation.
I hope I haven't waffled. Can someone help?
Regards
Paula