Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 07:52 AM.


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