Database Selection

[WEG]

Hi everyone,

Is there a way to search from a form for a record in one database, then if
it is not found in the first database, the search continues in another
database until the record is found?

Any help is appreciated.

Thanks

[Larry Linson]

"WEG" <we******@verizon.netwrote

Is there a way to search from a form for
a record in one database, then if it is not
found in the first database, the search
continues in another database until the
record is found?

Yes, you can link the Tables in the different Databases, but the details
will depend on how you are planning to "search". If you are searching a
particular Field for a particular value, it shouldn't be too difficult.

But, just a caution, often people post here asking about "records in
databases" using terminology from other database software, when they really
mean "records in tables" in Access terms. That, too, would significantly
affect the details of the search (and possibly would indicate some design
issues with your database, too)

If you'd care to clarify, it's possible that someone could offer a useful
suggestion.

Larry Linson
Microsoft Access MVP

[bobh]

Hi,
If both tables are identical and you don't care from which table it
finds the match from then you could create a 'union' query and use it
as the recordsource of the form.

but, I do agree with the others, having two tables, one for active and
one for inactive, is not good and it will continue to bite you over
and over.
bobh.

On Jul 1, 5:11 pm, "WEG" <[e-mail]:

Hi everyone,

Is there a way to search from a form for a record in one database, then if
it is not found in the first database, the search continues in another
database until the record is found?

Any help is appreciated.

Thanks

[bobh]

Hi,
If both tables are identical and you don't care from which table it
finds the match from then you could create a 'union' query and use it
as the recordsource of the form.

but, I do agree with the others, having two tables, one for active and
one for inactive, is not good and it will continue to bite you over
and over.
bobh.

On Jul 1, 5:11 pm, "WEG" <[e-mail]:

Hi everyone,

Is there a way to search from a form for a record in one database, then if
it is not found in the first database, the search continues in another
database until the record is found?

Any help is appreciated.

Thanks