Re: auto fill data into one table based on data from a linked tabl
- From: Freida <Freida@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 5 Sep 2007 05:38:02 -0700
tblBudget
Budget Name -Primary Key
Beg. Date
End Date
Description
tblBudget_Acct
Budget Name
Budge_Acct_ID(Auto Gen)-Primary Key
Company
Account_Number
Period_Ind
Variance_Ind
Variance_PCT_over
Variance_PCT_under
Variance_AMT_over
Variance_AMT_under
Curr_Budget
Prior_Budget
Prior_Actual
tblBudget_Acct_Detail -No primary key
Budget Name
Budget_ACCT_Id
Company
Account Number
Status_Ind
Budget Month
Budget Year
Accouting_Period
Current_Budget_Amount
"Jeff Boyce" wrote:
I'm having a bit of trouble visualizing your table structure. Could you.
post back with a description, maybe something like:
tblPerson
PersonID
FirstName
LastName
DateOfBirth
tblClass
ClassID
ClassTitle
ClassDescription
....(this is just an example, not related in any way)
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Freida" <Freida@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DABECD5-A818-4805-82A0-F36B6BF884A9@xxxxxxxxxxxxxxxx
The budget name is what links the tables together, but each table contains
different fields. The Budget table contains the budget name, year and
description, budget accounts contain on the GL , the company, wheather the
budget its Monthly, annually, or quarterly. the account detail breaks it
down
even further. Account and account detail are almost the same but the
account
contains variances, and account detail breaks the budget down to the
actual
accounting period.
Plus the Budget name in one of the tables is auto filled, what is causing
the auto fill to the account table? The Budget table is linked exactly
the
same to account table as it is to the account detail table.
"Jeff Boyce" wrote:
You don't!
Although Access tables look like spreadhseets, they aren't. Access
tables
store data, Access forms display it.
If you already have a table that lists budget account and name, you don't
need to duplicate budget name in another table. That's what
budget/account
is for, to point at the name.
If you are working directly in the tables, spend some time familiarizing
yourself with forms.
If you tables have "lookup" data type fields, be aware that these store
one
thing (the account number/ID), but display something else (the
title/name).
Using these lookup fields in tables will cause you considerable
frustration...!
Good luck
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Freida" <Freida@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8FBC1CC5-2A14-47B8-8EF3-184AD274C7A3@xxxxxxxxxxxxxxxx
I am having a problem, I have created a budget data base that contains 3
tables
Budget, budget accounts and budget account detail. There is a
relationship
btwn all 3 of the tables.
in the budget table when you put the budget name in, the budge name in
budget accounts autofills but the budget name in the Detail table
doesnt.
My form had the budget table info and contains a subform with the
account
and account detail.
How do I get the budget name in the Account detail to fill
automatically?
- Follow-Ups:
- Re: auto fill data into one table based on data from a linked tabl
- From: Jeff Boyce
- Re: auto fill data into one table based on data from a linked tabl
- References:
- Prev by Date: Re: How can I refresh data in a calculated field on my main form after sub form data changes?
- Next by Date: Re: Disable Record Scrolling
- Previous by thread: Re: auto fill data into one table based on data from a linked tabl
- Next by thread: Re: auto fill data into one table based on data from a linked tabl
- Index(es):
Relevant Pages
|
|
