Working on a fairly simple point of sale system for a volunteer organization but my brain is starting to melt.
There are two taxes here and each product can have either one, both, or none. If that's not bad enough I have to break out the taxes for reporting. So rather than a fixed amount typed into each product I figured I'd put the tax rates into a "singleton" table that holds the organization's information. That table only has one row.
So the "Has" fields are intended to be used when creating the invoiceline record. The idea being that if it's true then calculate the mount as the line subtotal time the properties tax rate.
Since prices and tax rates change I thought it best to calculate and store the taxes with the invoiceline so that changing the product price or tax rate later wouldn't change the invoice amounts.
Where I'm running into brain destruction it figuring out how to use the fields from the singleton table that has no relations with the invoicelines.
My question is whether or not this is a good way to handle the taxes or whether there's a better way to store and apply the tax rates? If this is a good way then my next question about getting the value from the first row of an unrelated table will be asked in the queries sub forum
Thanks!
Edit: Sorry, can't figure out how to remove the extra attachment....