Using Country field to determine VAT Rate.

[BobJ]

hey,

i have a customer form which includes a "Country" combo box.. the reason i did this is because i have a separate table with a list of countries and their VAT (Value Added Tax, you americans call it sales tax i think ) rates.

i want this country saved in the customers table.. i need the country table to act merely as a source of data. Now ive spent a good hour tying to fix it messing around with the relationship between the two tables and the combo box itself.. but ive only been able to come to two end results

a) access tells me i cant save the new customer record cause a related record is required in the country table.

b) access enters a new line in my country table with the autonumber of the country selected on the add new customer form in the Country field.

im stumped as to where the problem is:// how can i fix it?

 

[neileg]

Check your combo properties. The control source should be the country field in the customers table, the row source should be your country table.

As an accountant, I'm a bit puzzled as to why you need to know the customers VAT rate. Unless you as a seller have a VAT registration in that country, you don't charge the local VAT rate.

 

[GaryPanic]

same question as to tax

I do insurance - and its where the insured is domiciled
(4 month rule -hm customs- tax) that is the correct tax to apply

outside of insurance
if you buy a car in germany - you pay german tax - recoup this upon coming back to the uk and pay VAT on this .

 

[BobJ]

oh... it would seem my manager has no idea what he's doing then... i just confirmed what you said with our sales team tho.. well theres a couple hours of pointless work done..

Thanks mate.

 

[GaryPanic]

Also as an after thought - some terroroties - you don't have to do the tax- but make the client responsible for this tax amount -- (Outside Europe)

but you are getting into a real nightmare with tax ...

be careful with this
I know this isn't much help
but ...

 

[BobJ]

cheers m8s