Results 1 to 2 of 2
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    565

    Access Data Subset - database model


    I have Customers where i have all data and part of all data for specific customers.

    Click image for larger version. 

Name:	Screenshot_1.png 
Views:	17 
Size:	17.8 KB 
ID:	33820

    So All Customers data will be for example
    Operating Systems: Windows, Linux Ubuntu

    but Customer 1 will have only Linux.

    How to create proper model for this?

    I created in table Customers two records:
    All Customers (set with all data)
    and Customer 1 (part of it),

    my boss wants to ghet mechanism for changing data easily.
    Where you change data in All Customers also Customer1 data should be changed.

    I think that this should not be problem because for data mainly i am using junction table like in screen attached:

    Click image for larger version. 

Name:	Screenshot_1.png 
Views:	16 
Size:	77.6 KB 
ID:	33821

    But this is working like this:
    when user changes data in main set of data (all data) there will be not change within customer1 records.
    I can do it via changing all tables data related to junction table.

    What you think?
    My approach is good here?

    thank you Guys for helping,
    Best,
    Jacek

  2. #2
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    565
    anyone ?

    Jacek

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

Similar Threads

  1. Help with data model/er diagram
    By Beanie_d83 in forum Database Design
    Replies: 4
    Last Post: 06-22-2016, 07:25 AM
  2. First Database Model with Table Design.
    By NightWalker in forum Database Design
    Replies: 6
    Last Post: 05-24-2016, 02:40 PM
  3. Bill of Materials Data Model
    By uaguy3005 in forum Database Design
    Replies: 3
    Last Post: 12-21-2015, 02:56 PM
  4. Importing excel into access data model
    By aisling21 in forum Access
    Replies: 2
    Last Post: 05-12-2015, 07:03 AM
  5. Transform data model from Access to X
    By snoopy in forum Database Design
    Replies: 2
    Last Post: 05-29-2012, 12:37 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