Results 1 to 3 of 3
  1. #1
    khwaja is offline Novice
    Windows XP Access 2002
    Join Date
    Dec 2009
    Posts
    4

    Database Design for Specification Database

    I am planning to ceeate a tool to maintain specifications. These may vary by business, may have differents kits for each business, and may have sections and sub sections for each kit and finally some description under each sub section. A case of 1to m relationships, I suppose.



    I am struggling with the design and would like it so that that navigation and maintenance is easier. I can create seperate tables but don't know how best to capture these in forms. Will appreciate some guidance. Thanks.

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Start out learning by trying the Access Form wizard. Adjust your form after it's constructed by the
    Wizard.

  3. #3
    kp123 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    33

    Clarification...

    llkhoutx, does your suggestion relate to the transfer of all required fields into one form, then splitting it across several tabs within that form?
    This is essentially what I want to do but I have a large number of fields in 19 different categories (I want to split into tabs) so it won't let me move so many across in one go for splitting later!
    Any ideas...?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Design for a School
    By FallingToaster in forum Database Design
    Replies: 2
    Last Post: 08-12-2009, 10:47 PM
  2. Database Design
    By mzrihe1x in forum Database Design
    Replies: 1
    Last Post: 06-17-2009, 09:09 PM
  3. Database Design Issue
    By joekiteire in forum Database Design
    Replies: 6
    Last Post: 02-26-2009, 04:53 AM
  4. Database Design Problem
    By Kurth in forum Access
    Replies: 0
    Last Post: 08-14-2008, 04:09 AM
  5. Need help checking database design
    By abc7 in forum Database Design
    Replies: 1
    Last Post: 10-29-2007, 08:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums