|
| 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
October 7th, 2008, 08:54 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
October 7th, 2008, 11:44 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
October 8th, 2008, 12:01 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
October 8th, 2008, 12:09 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
October 8th, 2008, 02:07 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
October 8th, 2008, 02:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
