Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
  1. #31
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142

    Still waiting on that plain english explanation of what you're doing. I have plenty of ideas but at this point would be guessing.

  2. #32
    Deepak.Doddagoudar is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Sweden
    Posts
    43
    I am trying to build new combinations, like a Lego. For example you have one initial combination already existing with you and you want to build a new one. You take a NEW main part and build a new combination using existing parts.

  3. #33
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Okay. Then are you generally always working the same lists of MachineSystems, MachineSubsystems, and Components?

    Can a single distinct Component be linked to multiple distinct Subsystems?

    What is the purpose of the master data table? Is there ONE record in the master data table for each combination?

    Are the components the real "nuts and bolts" of this? Are the Systems and Substems just groupings of Components for convenience ?

  4. #34
    Deepak.Doddagoudar is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Sweden
    Posts
    43
    Yeah, Generally working with the same list of MachineSystems, MachineSubsystems, and Components but I can create new ones as well, sometimes.
    Yeah,
    a single distinct component can be linked to multiple distinct subsystems.
    Apart from the four main fields i have many other fields. I have created a drop down for those fields so that i can link different records to different components.
    Yeah components are real last level of hierarchy. you can call them "nut bolts". I did not understand your last question.

  5. #35
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Can you elaborate a little more on "MasterData"? Is it just a table with extended information for each component? Should there be only one record of MasterData for each component and vise versa? Or is supposed to be multple MasterDatas for each Component?

  6. #36
    Deepak.Doddagoudar is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Sweden
    Posts
    43
    The master data consists of a foreign key for components records. There are multiple records for each component and vice versa. That is why I have given a drop down for the other fields.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiselect Multiple Listboxes
    By Deepak.Doddagoudar in forum Forms
    Replies: 29
    Last Post: 03-15-2018, 03:26 PM
  2. Replies: 11
    Last Post: 02-02-2017, 10:31 AM
  3. Adding Records from MultiSelect ListBox
    By Voodeux2014 in forum Forms
    Replies: 3
    Last Post: 10-16-2015, 09:22 AM
  4. Replies: 5
    Last Post: 02-05-2013, 01:18 PM
  5. Combining data from multiple listboxes
    By dshillington in forum Access
    Replies: 1
    Last Post: 10-04-2012, 11:53 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