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 bus...
Forum Discussion
Regarding the stand-alone table, I'd suggest just google-ing List of US States and you should be able to find something you can copy/import into Quickbase.
Next, the relationship. Once you have your States table created, set the State Name as the key field. Next, create a relationship to the Customers table where the State is the Parent. Then, change the new 'Related State' field to a Formula Text field where the formula is just the [Address: State/Region] field. Finally, in the relationship, bring over your 'Nexus' field as a Lookup.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Next, the relationship. Once you have your States table created, set the State Name as the key field. Next, create a relationship to the Customers table where the State is the Parent. Then, change the new 'Related State' field to a Formula Text field where the formula is just the [Address: State/Region] field. Finally, in the relationship, bring over your 'Nexus' field as a Lookup.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Thanks to all. That was very easy to set up.
Wade C. Myers, C.E.O.
LightSpeed PM
Office - (502) 653-7410 | Cell - (502) 529-6145
Email - Wade.Myers@LightSpeedPM.com | Website - www.LightSpeedPM.com
Certified Partners with:
Quest Software, One Identity, Optimiz, Dell, SmartBear, Arcturus
Certified on SAM.gov – Cage Code 87NX5
