The Sharepoint list does not but let me see if I can explain it breifly and it make sense????
There are two Main data sources that are both Sharepoint XML Form documents libraries and a couple of support lists including this list I'm using as a secondary data source in this form.
This system collects test results at various stages of manufacturing and the first Main data source slowly gets built as the testing progresses. These tests are of components that eventually may be combined to produce a finished product. Part of the test results that are captured include chemistry's of a batch of raw material. This raw material will ultimately be used to produce any number of half-products as we call them. Each of these half-products is tested and the results recorded and the chemistry is included from the raw material level so there may be 20 records in this form library that may all be different except for the field that identifies this chemistry will all be the same for all 20 records because it came from the same raw material.
Then 5 to 7 of these half-products will be blended together to make a single finished product. I have to produce a printed certificate that is sent along with the finished product showing all the tests that were done on the half-products and the finished product. There is a linkage that is created during production that ties the 5 to 7 half-products to a new finished product test which includes all the test data from all half-products and the chemistry numbers from each product.
When it's time to produce the certificate they would enter the new finished product test ID and that pulls in the test results from the 5 to 7 components. Some of these could have the same chemistry number. some might not. frequently all the components come from one raw material batch so they all have the same chemistry but sometimes it will span two batches and it could span 7 batches.
They do not want to repeat this chemistry information for each component product. It is just summerized on the form elsewhere. So this repeating table would normally probably only contain one row and possible two but it could contain 7.
As I load the component test results I take the chemistry number from the component test and then use it as the filter to load the repeating table from the secondary data source. At this point if the row with that chemistry number is already in the repeating table I would like to either not insert it again or filter it from view. It really doesn't matter as long as it is not seen more than once.
Told you it wouldn't be short!
Anyway that's what I need to do. I can find my way around JavaScript if needed and have some pieces I'm using for simple things already but i'm not doing in C# in this at all as I barely know C#. So rules or JS is what I'm looking for.
Had we known this was going to get this invovled I would have just done it in VB with a SQL backend but almost done with at this point with everything else working as desired. It is a temporary solution so we were tying to avoid writing a entire system from scratch for use of less than a year.
Thanks for your help!! And yes, I know you're sorry you asked now!!!!