By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Dire need of Help!

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.