re:Best way to set up accounts and sub-accounts
- From: noahecochran@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (nc)
- Date: Sat, 14 May 2005 03:40:15 -0500
I am learning Access myself. The approach I would take is to have a
separate table for accounts and for subaccounts as you have done. In
the subaccount table add an Acct field. Go to design view and for the
Acct field in the Subaccount table go to the Lookup tab and select
combo box for Display Control; for Row Source Type select
Table/Query; for Row source, doubleclick on the three dots and select
your accounts table. This should open up your accounts table in query
view. Add fields to query that you want to show up in the drop down
box. For bound column, select the appropriate column number. For
example, if you have acct # as 1st column and acct name as second,
select 1 if you want the account number added to the table or 2 for
account name. The rest of the options should be easy to figure out
if you understand this much. Hope this helps.
.
- References:
- Best way to set up accounts and sub-accounts
- From: Brent Walker
- Best way to set up accounts and sub-accounts
- Prev by Date: Re: Create Table SQL not working
- Next by Date: Re: Create Table SQL not working
- Previous by thread: Best way to set up accounts and sub-accounts
- Next by thread: Alternative to Check Boxes
- Index(es):
Relevant Pages
|
