autofill help!!

[noe1818 via AccessMonster.com]

Here's my scenario (watered down):

TalbeA
id
ass#
info1
etc

TableB
id
ass#
info2
etc

I want a main form that has 2 control tabs. In the first will be info from
TableA. In the 2nd tab will be info from TableB + "info1" from TableA. I'm
doing this because "info1" will be used to make a descision for "info2". What
do I need to do so that when TableB is selected from the tab control "info1"
is populated or autofilled? I have to work within this design. I would so
love some help on this. IF you use code, please use my examples, so I can
just cut and paste.

-Noe

 

[Jeff Boyce]

Noe

I may be reading too much into the table structure you provided, but it
looks like you are using one table for each "info" type. We aren't there,
and can't tell what you are storing in these tables, but any time I see
"identical" tables, I suspect that the data is organized more like a
spreadsheet than a relational database.

To get more specific suggestions, please provide more specific descriptions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[noe1818 via AccessMonster.com]

My tables are related. The first table is a table dedicated to personal
information. The second table in my example is acctually my last table in my
DB, it's my summary table. The info needed to make diagnoses of patients is
taken from the personal info(weight, height, etc) and used subjectively to
make desicions that are stored in summary table (TableB). So, I what the info
from TableA to show up on form 2. If you need any other info on my design let
me know

-Noe

Noe

I may be reading too much into the table structure you provided, but it
looks like you are using one table for each "info" type. We aren't there,
and can't tell what you are storing in these tables, but any time I see
"identical" tables, I suspect that the data is organized more like a
spreadsheet than a relational database.

To get more specific suggestions, please provide more specific descriptions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Here's my scenario (watered down):

[quoted text clipped - 21 lines]

-Noe

 

[Jeff Boyce]

Aha, that's a different story!

You can have more than one form pointing to the same table, so you don't
need to copy data from TableA to TableB just to get it to show up on a
(separate) form.

Better still, you can use multiple queries to get different sets of
data/different summarizations of data from a single table, and use each
query as the source for a different form.

Access tables store data, Access forms (and reports) display data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

My tables are related. The first table is a table dedicated to personal
information. The second table in my example is acctually my last table in
my
DB, it's my summary table. The info needed to make diagnoses of patients
is
taken from the personal info(weight, height, etc) and used subjectively to
make desicions that are stored in summary table (TableB). So, I what the
info
from TableA to show up on form 2. If you need any other info on my design
let
me know

-Noe

Noe

I may be reading too much into the table structure you provided, but it
looks like you are using one table for each "info" type. We aren't there,
and can't tell what you are storing in these tables, but any time I see
"identical" tables, I suspect that the data is organized more like a
spreadsheet than a relational database.

To get more specific suggestions, please provide more specific
descriptions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Here's my scenario (watered down):

[quoted text clipped - 21 lines]

-Noe