Results 1 to 3 of 3
  1. #1
    iceman.dk is offline Novice
    Windows 10 Access 2013
    Join Date
    Feb 2016
    Location
    Denmark
    Posts
    4

    How to enable only editable fields

    Hi

    I'm working on a product database which store product attributes.

    A product has a field named "category_set".
    This field should determine which attributes the user can see and edit in a form.

    I have about 20.000 products and 50 different category_sets, which contains up to 250 different attributes.

    My product table named tbl_products contain this fields:
    SKU
    Productname
    Category_set

    Examble data:
    1000 Demoarticle A Wheel
    1100 Demoarticle B Engine

    My category_set table named tbl_categorySet contains this fields:
    Categoryname
    Attributevalue

    Examble data:
    Wheel Size
    Wheel Pattern
    Engine Volume
    Engine Cylinders
    Engine Turbo

    My attributevalue table named tbl_attributevalue contains this fields:
    SKU
    Attributename
    Atttributevalue

    Examble data:
    1000 Wheel 17 inch
    1000 Wheel Slick
    2000 Volume 2000 ccm
    2000 Cylinders 4
    2000 Turbo Yes

    How can I make the form only showing the relevate attributes, then the category_set is selected for a product?

    Is there a better way to store data, than my current solution with 3 tables?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The Subject of this thread seems a bit off from what you are asking or is it me?

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Allan,
    I agree the subject does not reflect the details of the post.

    iceman,
    I recommend you give a 8-10 line description of the business and its major processes in plain English. Start with a 30,000 foot overview and add any info to help make the pieces fit together.
    What do you do with these products -- make, sell....?
    You should research database design and Normalization.

    You may get some insight from the free data models at this site.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-20-2014, 02:04 PM
  2. None of my form fields are editable...why?
    By logan3975 in forum Forms
    Replies: 11
    Last Post: 11-19-2013, 10:29 AM
  3. Replies: 4
    Last Post: 03-05-2013, 09:03 AM
  4. Replies: 3
    Last Post: 09-29-2010, 09:31 AM
  5. making specific fields non-editable
    By narayanis in forum Forms
    Replies: 3
    Last Post: 08-06-2008, 12:22 PM

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