I have a dataset that contain 2 tables.
Table 1 = Child Table
Table 2 = Master Table
The dataset tables has got the Parent Child relationship using the following code:
What I want to achieve here is the filtered records using a criteria. For example the records of only the employees (Master Table) which are currently working in the company and not the leavers. To do that I need to use one of the columns in the master table but the records from the child table will be used to display on the form.
I hope I am clear explaining the problem.
Could anybody help please?