Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 19th, 2005, 12:18 PM
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Listboxes Sub-Listboxes and Table Linking

Basically what I'm trying to do and need some assistance and direction on where to start:
Example:

TABLES:
I need to have a main table tblemployees, a categories table tblcategories, a main privileges table tblprivileges and a subprivilieges table tblsubprivilieges and have them all link back to one employee record for many selected categories, privileges and subprivileges.

FORM:
I wanted to use listboxes to select the appropriate categories, privileges and subpriviliges, for example on an input form have the categories listbox then depending on the selections in the categories listbox have the privileges listbox appear with the appropriate choices then depending on the selections in the privileges listbox a third subprivileges list box would appear with the appropriate choices and finally have all of these link back to the main employee record.

Any help is much appreciated!

Thank you,

MJB05
  #2 (permalink)  
Old September 19th, 2005, 01:29 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Do a search at MSDN for cascading list or combo boxes for the latest techniques for your forms.

Do you need help with the table structure?


mmcdonal
  #3 (permalink)  
Old September 19th, 2005, 03:25 PM
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you sooooo much! I've been posting this topic to different Forums all day and this is the first Reply I've received! I'll search and let you know if I find anything. And yes I do need help structuring the data and tables.

Thank you again!

MJB05
  #4 (permalink)  
Old September 19th, 2005, 03:56 PM
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, maybe I just overlooked it, but unfortunately I didn't see anything that would really help me get going on this? If you have anymore ideas I would really appreciate them!

Thank you,

MJB05
  #5 (permalink)  
Old September 20th, 2005, 12:37 PM
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by MJB05
 Well, maybe I just overlooked it, but unfortunately I didn't see anything that would really help me get going on this? If you have anymore ideas I would really appreciate them!
 You might try looking here.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Listboxes and Checkboxes vanguardmike Classic ASP Basics 2 January 2nd, 2007 05:28 PM
getting Listboxes to communicate susan_ny ASP.NET 2.0 Basics 1 January 26th, 2006 11:41 PM
Listboxes and Arrays interrupt Javascript How-To 1 August 2nd, 2004 01:55 PM
Filtering listboxes Bill Snow VB Databases Basics 0 February 5th, 2004 03:32 PM
Listboxes Alaric VS.NET 2002/2003 1 October 29th, 2003 11:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.