Autolookup Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

I believe that I want to create an autolookup query that will allow users to choose from one pull down menu to select the type of part that they wish to create. Based on their selection I need the major category field and minor category field to automatically fill in. I've created tables to house all of the information for that part, one for the major category, one for the minor category, one for the description pull down menu. I understand that there needs to be a one - to - many relationship but cannot figure out how to create this. For example, if the user selects batteries then the major should update to read electrical and the minor should update to read battery. What tables do I need to create, reference and query?

Please help
 
Hi,

To begin with you are not going to be able to synchronize the drop downs
directly in Tables. You will need to use a Form. See the following
article for helpful hints:
ACC2000: How to Create Synchronized Combo Boxes
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Autolookup Query?
| thread-index: AcQSprNdGPoWvbmlTGOZqOtDPMX3FA==
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| From: "=?Utf-8?B?c25sQHJlcw==?=" <[email protected]>
| Subject: Autolookup Query?
| Date: Thu, 25 Mar 2004 12:21:05 -0800
| Lines: 5
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:77588
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| HI,

I believe that I want to create an autolookup query that will allow users
to choose from one pull down menu to select the type of part that they wish
to create. Based on their selection I need the major category field and
minor category field to automatically fill in. I've created tables to
house all of the information for that part, one for the major category, one
for the minor category, one for the description pull down menu. I
understand that there needs to be a one - to - many relationship but cannot
figure out how to create this. For example, if the user selects batteries
then the major should update to read electrical and the minor should update
to read battery. What tables do I need to create, reference and query?

Please help
|
 
Back
Top