I have two datasets, 1 old and 1 new which I have joined via the PK.
Both contain 2 columns, Sub_Code and Sub_Name
Problem is the Sub_Code/Sub_Names in the new dataset have been aggregated (there are more subjects in the old dataset, fewer in the new dataset) – and therefore I need to map the two so that when something is selected in one dataset the relevant is selected in the other dataset.
In the old dataset:
In the new dataset:
So if Sub_Code 1 was selected in the new dataset, Sub_Code’s 1,2 & 3 would be displayed from the old dataset.
Any ideas? I thought of creating a key or something via an inline load?