auto fill data into one table based on data from a linked table

[Guest]

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?

 

[Jeff Boyce]

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

 

[Guest]

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]

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

 

[Guest]

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]

Why does Company and Account_Number show up in the "detail" table, when you
already have Budget_Acct_ID?

Regards

Jeff Boyce
Microsoft Office/Access MVP