Question about Switchboard and about Linking Tables

[Wendy]

1) I want to add saved Queries to my switchboard, but don't see how to do
that easily since running a query is not one of the 'operations' offered. I
have followed the HELP and think what I'm supposed to do is create a Command
button on the switchboard form, and I did so, but the result is searching on
a field which has nothing to do with the desired query. How do I tell it
the name of the Query to be used?

2) I want to create a Query which will search for Last Name (the query
prompts the user to enter the last name; [Type in Last Name: ] in Criteria)
across two tables which have similar data but nothing to link them
relationally. To be more specific I am working with approx. 24,000 records
from a doctor's office. Fields are the obvious: last name, first, address,
city, ssn, etc. The only similarity is the type of information. I'd like
to be able to search for Last Name = "Brown" in the newer records first,
then into the older records without the user having to do anything unique.

Thanks in advance for any and all assistance. Feel free to direct your
response to wjnm @ yahoo . com

 

[John Vinson]

1) I want to add saved Queries to my switchboard, but don't see how to do
that easily since running a query is not one of the 'operations' offered. I
have followed the HELP and think what I'm supposed to do is create a Command
button on the switchboard form, and I did so, but the result is searching on
a field which has nothing to do with the desired query. How do I tell it
the name of the Query to be used?

Query datasheets should generally NOT be displayed to users, so it's
not something you would ordinarily want to put on a switchboard at
all. Instead, base a Form on the query, and open the Form from the
switchboard.

2) I want to create a Query which will search for Last Name (the query
prompts the user to enter the last name; [Type in Last Name: ] in Criteria)
across two tables which have similar data but nothing to link them
relationally. To be more specific I am working with approx. 24,000 records
from a doctor's office. Fields are the obvious: last name, first, address,
city, ssn, etc. The only similarity is the type of information. I'd like
to be able to search for Last Name = "Brown" in the newer records first,
then into the older records without the user having to do anything unique.

A UNION query will let you string your two tables together; see UNION
in the online help, or post back if this is confusing.

Thanks in advance for any and all assistance. Feel free to direct your
response to wjnm @ yahoo . com

Private EMail support is available at my standard consulting rates;
otherwise, please ask here, and come back here for the answer, so
others can benefit.

John W. Vinson[MVP]
(no longer chatting for now)