Calculating for Nexus
Part of the rules associated with taxes (when selling products or services to other states) requires that you evaluate whether or not you have a nexus with the particular state which you are doing business with.
My goal would be to build a table with all 52 states listed and have a simple check box next to any state where you have a nexus, and then associate it with customers, and use the information to feed down into quotes.
so, for example if I have 6 customer total and 3 customers are also in Kentucky. The nexus check box next to Kentucky in the states table would be evaluated as true for the 3 customers.
So, the first thing I need is a pointer to a stand alone table of US States if anyone has that. The second thing I need is help understanding how I would compare just the State sub field of the Address field of my Customers table.
------------------------------
Wade Myers
------------------------------
My goal would be to build a table with all 52 states listed and have a simple check box next to any state where you have a nexus, and then associate it with customers, and use the information to feed down into quotes.
so, for example if I have 6 customer total and 3 customers are also in Kentucky. The nexus check box next to Kentucky in the states table would be evaluated as true for the 3 customers.
So, the first thing I need is a pointer to a stand alone table of US States if anyone has that. The second thing I need is help understanding how I would compare just the State sub field of the Address field of my Customers table.
- I'm pretty sure I need a many to one relationship, one state to many customers
- I'm a little foggy on how I set up that relationship and compare it.
------------------------------
Wade Myers
------------------------------
