Forum Discussion
Data filtering between tables problem
The only way to prevent it is to clean up the data. You need to make sure either that table 3 has all possible values which could appear in table 2 or 4, or that table 2 and 4 do not include values which are not in table 3.
Exactly how you do you this will depend on your specific case, but you could potentially do an inner join between table 3 and tables 2 and 4 to ensure that only valid values from table 3 appear in tables 2 and 4. Or append values from tables 2 and 4 into table 3 if they are not already there.
The only way to prevent it is to clean up the data. You need to make sure either that table 3 has all possible values which could appear in table 2 or 4, or that table 2 and 4 do not include values which are not in table 3.
Exactly how you do you this will depend on your specific case, but you could potentially do an inner join between table 3 and tables 2 and 4 to ensure that only valid values from table 3 appear in tables 2 and 4. Or append values from tables 2 and 4 into table 3 if they are not already there.