Can one Form feed different tables?

[Guest]

I have several tables, each one representing a different agency, and would
like to know if it is possible to design one form that feeds each respective
table. What I envision is filling in all the information on one form, but
the last item to fill in has a drop down list of the different agencies. I
select the appropriate agency and the data is added to that agency's table.
Trying to avoide one huge table covering all the agenencies as well as trying
to avoid one form per agency. Any ideas?

 

[Steve Schapel]

IT Ed,

What is your reason for "trying to avoid one huge table covering all the
agencies"? What you are doing is sometimes referred to as the "tables
as data trap". This is not the way that Access works best (or any
relational database, for that matter). What you are suggesting is
certainly possible, but as far as I can see, not advisable.

 

[Larry Linson]

I have several tables, each one representing a different agency, and would
like to know if it is possible to design one form that feeds each
respective
table. What I envision is filling in all the information on one form, but
the last item to fill in has a drop down list of the different agencies.
I
select the appropriate agency and the data is added to that agency's
table.
Trying to avoide one huge table covering all the agenencies as well as
trying
to avoid one form per agency. Any ideas?

Almost certainly, if you have identical tables for the different agencies,
that means the table itself is "data" and that would be a violation of
relational database design rules. Those rules aren't arbitrary, but are how
a RDB should be designed to be effective.

Again, almost certainly, you should add a field indicating the agency, and
combine the multiple tables into one. You'll certainly find it easier to do
various types of querying and analysis.

Larry Linson
Microsoft Access MVP