I have a form that displays measurements of tools. These tools are specific in that they have a part number. However, there are several tools that have the same part number. Each tool with the same part number is being measured individually. The tools that are being measured individually are measured in batches.
For example, tool AR555 is a specific make of the tool, but there could be a hundred AR555's being measured. out of the hundred there could be 4 different batches of 25
As a result, I have multiple AR555 instances in my table. they are separated into batches. What I want to do is look up AR555 and, instead of showing only the AR555 associated with a batch(25), have it display all instances of AR555(100)-Combine all instances of AR555.
As it stands, when I go to look up a part number in my combo box, there are several instances of AR555, depending on the number of batches. In this case 4 instances of 25.
1)The first thing I would like to do is have my combo box only show one instance of AR555 even if there is multiple instances(I would be showing all results of AR555 so there wouldn't be a need to have them separated).
2)The second thing I would like to do is have all instances of AR555 combined in the subform in a single datasheet view after it is selected from the list box.
Note: AR555 is not an actual Part Number
An example of the db is attached, just in case I didn't explain it correctly.
Hope its not to confusing- Thanks