I know zero programming so I'm going to explain what I want to do and hopefully you guys can give me some ideas on what I need to learn to accomplish this.
So I have a master list of items (say 10k). This list is made up of sublists (say 100) of anywhere from 40 to 800 items. The order of items in the lists is important. I want users to be able to select 3-5 sublists and output a list of those 3-5 sublists in the correct order. An individual item might appear on multiple sublists but would only be outputted once.
Example:
Master List:
Ram 1
Ram 2
Chevy 1
Lion 1
Apple 1
Apple 2
Ram 3
Orange 1
Orange 2
Orange 3
Chevy 2
Dodge 1
Shark 1
Shark 2
Sublists are:
Cars, Fruits, and Animals
Cars | Fruit | Animals |
Ram 1 | Apple 1 | Ram 1 |
Ram 2 | Apple 2 | Ram 2 |
Chevy 1 | Orange 1 | Lion 1 |
Ram 3 | Orange 2 | Ram 3 |
Chevy 2 | Orange 3 | Shark 1 |
Dodge 1 | | Shark 2 |
So then a user selects Cars and Animals and they would get a list like this:
Ram 1
Ram 2
Chevy 1
Lion 1
Ram 3
Chevy 2
Dodge 1
Shark 1
Shark 2
Outputting the list similar to the above, with spaces between different items but not the same items with different numbering is important too but I guess that just depends on how you format the final result.
=========================================
Now having no idea how to do this my thought would be to make a database of the master list, marking each item with whatever sublists they would show up in and giving each item a number to sort them in the master list. So keeping with the above example:
Item Name | Order | Sublist |
Ram 1 | 00010 | Cars, Animals |
Ram 2 | 00020 | Cars, Animals |
Chevy 1 | 00030 | Cars |
Lion 1 | 00040 | Animals |
Apple 1 | 00050 | Fruit |
Apple 2 | 00060 | Fruit |
Ram 3 | 00070 | Cars, Animals |
Another thing is sometimes an item might have its position changed or 100 items might be added into a list, hence the space between the order numbers. Chevy 1 might switch to after Apple 1, I would just change the Order # for Chevy 1 to 00051 to put it after Apple 1. Or five items would be added between Apple 2 and Ram 3, I would give them order #s of 00061, 00062, etc.
So basically what I'm wondering is if I'm on the right track at all and what do I need to learn to accomplish it?
Last edited by Daer; 05-16-2017 at 11:24 AM.