If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Basic database design - using tables to feed lookups
This is going to be an easy one. I am creating a library database of books,
leaflets, brochures, etc. I want to have certain drop-down links (in cells) be restricted to specific inputs for the materials desriptions. I'm stumbling around MS's site with little luck so far. i.e. Categories: TYPE-drama, ficion, romance, etc (limited to my list) Details: Theme-suspence, action, etc (limited to my list) etc., etc. |
#2
|
|||
|
|||
Basic database design - using tables to feed lookups
You mention "database design" but then state "in cells". If you are using
Access, you would use the combo box wizard on forms to create dropdowns based on small lookup tables. -- Duane Hookom Microsoft Access MVP "nkuck" wrote: This is going to be an easy one. I am creating a library database of books, leaflets, brochures, etc. I want to have certain drop-down links (in cells) be restricted to specific inputs for the materials desriptions. I'm stumbling around MS's site with little luck so far. i.e. Categories: TYPE-drama, ficion, romance, etc (limited to my list) Details: Theme-suspence, action, etc (limited to my list) etc., etc. |
#3
|
|||
|
|||
Basic database design - using tables to feed lookups
On Fri, 9 Oct 2009 04:43:01 -0700, nkuck
wrote: This is going to be an easy one. I am creating a library database of books, leaflets, brochures, etc. I want to have certain drop-down links (in cells) be restricted to specific inputs for the materials desriptions. I'm stumbling around MS's site with little luck so far. i.e. Categories: TYPE-drama, ficion, romance, etc (limited to my list) Details: Theme-suspence, action, etc (limited to my list) etc., etc. "Cells" is an Excel concept; database tables don't contain cells. And you should not be looking at Table datasheets directly in any case - you should have a properly normalized set of tables, and use Forms (with combo boxes, dropdowns if you will) on the Form. Here's some resources to get started; Crystal's video might be a good jumping off point. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Basic database design - using tables to feed lookups
nkuck wrote:
This is going to be an easy one. I am creating a library database of books, leaflets, brochures, etc. I Fred might've already done a lot of the work for you. See Fred Boer Library Systems: Home of "My Library" and "My First Library" http://www3.sympatico.ca/lornarourke/fred.html Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a free, convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/ |
Thread Tools | |
Display Modes | |
|
|