Dire need of Help!

[VK]

Hello,
I am currently doing a project on Access and am current stuck in the
"search" process and hoping that you could help me out.
I have got 3 tables designed.
When the user clicks on search option based on the record # (not a
combobox), services, location, date (all combo boxes) the particular
record that is stored in the 'allinfo' table should be displayed. I
would like to know how to fetch the particular record as the service
details are in another table called "service" and the allinfo table
contains only the service id. If a user selects a service, how do I
get the service details, location details, and all the other record
details that are present in the allinfo table. I would like to know
how to use a multi-table query, so I can include fields from all the
related tables needed to search.
Code would be of great help.
Thanks in advance,
vk

[Salad]

VK wrote:

Hello,
I am currently doing a project on Access and am current stuck in the
"search" process and hoping that you could help me out.
I have got 3 tables designed.
When the user clicks on search option based on the record # (not a
combobox), services, location, date (all combo boxes) the particular
record that is stored in the 'allinfo' table should be displayed. I
would like to know how to fetch the particular record as the service
details are in another table called "service" and the allinfo table
contains only the service id. If a user selects a service, how do I
get the service details, location details, and all the other record
details that are present in the allinfo table. I would like to know
how to use a multi-table query, so I can include fields from all the
related tables needed to search.
Code would be of great help.
Thanks in advance,
vk

The first thing that comes to mind is to hire a programmer fron this
newsgroup.

You have a table callid AllInfo that contains 1 field which is the Key.
This should be linkable to your service and location detail tables.
You could create a form for listing service details. Then create
another form for location details. Then create a form where the
recordsource is AllInfo and drop in the Service and Location forms. The
common link would be the key in AllInfo.

Your problem is difficult to understand. You could take the concept
above and expand on it.