Re: autofill help!!

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

"noe1818 via AccessMonster.com" <u39419@uwe> wrote in message
news:7c63152062ea5@xxxxxx
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

Jeff Boyce wrote:
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
spread*** 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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200712/1



.

Quantcast