hi I'm currently working on a accounting system
my problem is with the tax
main windows looks something like this(simplyfied)
BkID BkDate BkTekst FromAcountID ToAcountID BkTotal TaxID
20 10-03 Invoice 11 13 123 1
the meaning is, that when I i.e. type the tax id 1, it shall autogenerate a line with the tax for the line above.
how can I do this?
The tax table includes the following collumns:
ACVTID ACVTName ACVTText ACVT%
1 Domectic tax Tax of 25
please help me, since I don't know what to do.
PS: I know my VB, but I'm kinda new to access and sql
my problem is with the tax
main windows looks something like this(simplyfied)
BkID BkDate BkTekst FromAcountID ToAcountID BkTotal TaxID
20 10-03 Invoice 11 13 123 1
the meaning is, that when I i.e. type the tax id 1, it shall autogenerate a line with the tax for the line above.
how can I do this?
The tax table includes the following collumns:
ACVTID ACVTName ACVTText ACVT%
1 Domectic tax Tax of 25
please help me, since I don't know what to do.
PS: I know my VB, but I'm kinda new to access and sql