Create a front end to work of multiple tables

[Sean Staniforth]

I have a Database which contains anout 20 tables. each has different data.
for a research centre studying Family History.

I want to create a simple from end that researchers can entre a surname &
First name to find their ancestor, this will give them reference number
relation to the house

Then they will want to clear the two names and enter the reference numbers
(town / Village / house)
that will give census details of those living at that address.
Then need print option to print those records.

Each of the databases / tables will work in simular format, but all differ
slightly

If anyone can help I can provide sample data.

ss**@blueyonder.co.uk

[Allen Browne]

Sean, the only real solution here is to redesign the database so the 20
tables are combined into one. There will probably be a several fields that
don't apply to all cases, but you can still use 20 different forms if you
wish so the user is not bothered by those fields. (You may also need one
additional field to distinguish whatever is the difference between the 20
tables.)

That will be much more efficient that writing code that loops through the 20
tables, executing an Append query on each one to append the matching records
to a temporary table after execuing a Delete to clear the temp table, and
then presenting an interface of the matches in the temp table in such a
manner that the user can jump from there to the appropriate form for that
particular result.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sean Staniforth" <ss*********@blueyonder.co.ukwrote in message
news:wi******************@fe2.news.blueyonder.co.u k...

>I have a Database which contains anout 20 tables. each has different data.
for a research centre studying Family History.

I want to create a simple from end that researchers can entre a surname &
First name to find their ancestor, this will give them reference number
relation to the house

Then they will want to clear the two names and enter the reference numbers
(town / Village / house)
that will give census details of those living at that address.
Then need print option to print those records.

Each of the databases / tables will work in simular format, but all differ
slightly

If anyone can help I can provide sample data.

ss**@blueyonder.co.uk

[Larry Linson]

"Sean Staniforth" wrote

I have a Database which contains anout 20 tables.
Each has different data, for a research centre
studying Family History.

I want to create a simple from end that researchers can entre a surname &
First name to find their ancestor, this will give them reference number
relation to the house

Forms, reports, and querying are strong points of Access -- unless there are
"surprises" in the detail of what you are trying to accomplish, you can do
it in Access.

Then they will want to clear the two names and enter the reference

numbers

(town / Village / house)

Since you are obtaining the reference numbers from the same database, via a
search, and using them for another search, there's no reason that the user
should have to re-enter what was found.

that will give census details of those living
at that address. Then need print option to
print those records.

If you are using the information to search and return values from a query,
you could use the same query as the Record Source for a Report (or supply
the same values to limit the Records returned).

Each of the databases / tables will work in
simular format, but all differ slightly

That's rather vague, and not much help to us in helping you.

If anyone can help I can provide sample data.

It's always a good idea to be specific about what kind of help you seek.
Newsgroups are a good source of specific answers for specific questions;
they aren't a good place for a "tutorial" session on the Access product,
though sometimes there is good tutorial information in some of the answers.

Larry Linson
Microsoft Access MVP

ss**@blueyonder.co.uk