you said
You kind of lost me with the "null" value suggestion for the category field
CategoryPK autonumber
CategoryName text
CategoryFK long - links back to categoryPK which will be the primary category, if left blank (null), then it is a primary category
so a query like this will give you all your categories
Code:
SELECT *
FROM blCategories P INNER JOIN blCategories S ON P.CategoryPK=S.CategoryFK
WHERE P.CategoryFK is null
I am assuming that the DrBankID and CrBankID foreign keys are coming from the same table. If so, how would I go about updating both account records simultaneously?
you don't need to - it is the same record - amount would always be positive in this case so the accounts in the Cr field would multiply that value by -1 when adding up. Not sure what you mean by updating both account records - hope you don't mean you want the account tables to be updated with current balance - that is a no no. You don't need to - it is the same record - amount would always be positive in this case so the accounts in the Cr field would multiply that value by -1 when summing.