How can I achieve this requirement? Any help will be need to outer join the records you want to exclude, which in your scenario is those with a quarantine status is Reservation. So, the output which I want is below: NameĪlso, once I am able to show the above records in gallery then user wants a bulk insert to Preventive Quarantine Table for the multi-selected records with Quarantine_Status = "Reservation".
Now, my requirement is to filter the PopulationMaster Table where Quarantine_Status "Reservation", here Quarantine_Status is present in Preventive Quarantine Table. PopulationMaster_Lookup (this is a lookup field) PreventiveQuarantine_Id (this column is Unique Identifier) In below table, we have PopulationMaster_Lookup field which is related to Table1 i.e PopulationMaster.
I am adding some dummy/random data PopulationMaster_Id (this column is Unique Identifier) I am having one requirement where I have to filter a table data using a lookup field present in another table.
0 kommentar(er)
