Sales tax by zipcode
Im newish to filemaker (never had to do anything too advanced)... Im working on an invoicing application for field technicians.
Im having trouble with the sales tax, I would like it to look up the zip code and return the related sales tax for that zip. i only have about 50 zip codes we service.
I have a table customers and tax, Customers has the zipcodes and where i want it to return the tax rate. The tax file has the zipcodes and related sales tax. Im having trouble with the lookup.
Could someone give me a general idea of how to do this again Im new.
Thanks in advance