If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
subaccounts
I am working on a asset database and was wondering the best way to create
Main - sub - sub accounts for the types of assets? |
#2
|
|||
|
|||
subaccounts
TblAssetAccount
AssetAccountID AssetAccount TblAssetSubAccount AssetSubAccountID AssetAccountID AssetSubAccount TblAssetSubSubAccount AssetSubSubAccountID AssetSubAccountID AssetSubSubAccount Steve "G" wrote in message ... I am working on a asset database and was wondering the best way to create Main - sub - sub accounts for the types of assets? |
#3
|
|||
|
|||
subaccounts
Thanks, G.
"Steve" wrote: TblAssetAccount AssetAccountID AssetAccount TblAssetSubAccount AssetSubAccountID AssetAccountID AssetSubAccount TblAssetSubSubAccount AssetSubSubAccountID AssetSubAccountID AssetSubSubAccount Steve "G" wrote in message ... I am working on a asset database and was wondering the best way to create Main - sub - sub accounts for the types of assets? |
#4
|
|||
|
|||
subaccounts
"G" wrote in message
... I am working on a asset database and was wondering the best way to create Main - sub - sub accounts for the types of assets? What do you really need? Is it a unique account number for an asset that has several layers? A main account number containing a sub account number that could contain further divisions. In that case, the asset needs a unique key and should have secondary keys for the account, sub account and sub-sub account. John... Visio MVP |
#5
|
|||
|
|||
subaccounts
Hi G
I think Steve's suggestion is rather inflexible. What if you need more than three levels? What if you want to reclassify an account as being somewhere else in the hierarchy? I would favour a structure something like this: AccID (primary key) AccName AccParent (null for top-level accounts, otherwise the ID of the parent) AccOrder (the numeric order that the account should be listed among its siblings) AccPostable (boolean - whether or not transactions may be posted to this account [false for an account that is only a header]) -- Good Luck :-) Graham Mandeno [Access MVP] Auckland, New Zealand "G" wrote in message ... Thanks, G. "Steve" wrote: TblAssetAccount AssetAccountID AssetAccount TblAssetSubAccount AssetSubAccountID AssetAccountID AssetSubAccount TblAssetSubSubAccount AssetSubSubAccountID AssetSubAccountID AssetSubSubAccount Steve "G" wrote in message ... I am working on a asset database and was wondering the best way to create Main - sub - sub accounts for the types of assets? |
#6
|
|||
|
|||
subaccounts
Go with Graham's method. It is much better.
As Graham said, the other suggestion, although workable, is inflexible. "G" wrote in message ... Thanks, G. "Steve" wrote: TblAssetAccount AssetAccountID AssetAccount TblAssetSubAccount AssetSubAccountID AssetAccountID AssetSubAccount TblAssetSubSubAccount AssetSubSubAccountID AssetSubAccountID AssetSubSubAccount Steve "G" wrote in message ... I am working on a asset database and was wondering the best way to create Main - sub - sub accounts for the types of assets? |
Thread Tools | |
Display Modes | |
|
|