CSL - distinct values

[Nigel Hertz]

Hi, I'm creating a basic list to capture information in. It has 2 lookups to a list in another site. How can I filter the results from that list, so it only shows distinct values? The lookup list has multiple medicines in where specific batch numbers get split between different locations, so it'll have Drug-BatchNo repeated for several locations. I only want one copy of Drug-BatchNo returned. Is this possible?

[Dmitry Kozlov]

As I understood both lookups are linked to the same list. The first one contains Location, the second one - Drug-BatchNo. You want to display Drug-BatchNo values for the selected Location only, am I right?

[Nigel Hertz]

Almost. Sorry, we had a fire drill at work and I was trying to type quickly

List B references patients who get an injection. It includes 2 columns that are lookups to list A, which contains medicines.

List A includes 2 columns, one is Medicine and one is Location. As a specific batch can be split amongst different locations, there can be 3 records with the same medicine and batch number, but different locations:

Medicine Location

Adrenaline 5mg - AS3671 Newcastle

Adrenaline 5mg - AS3671 London

Adrenaline 5mg - AS3671 Edinburgh



In list B, I want to have a drop-down of the medicine column. I've got the dropdown, but as there are 3 records with the same medicine, it shows 3 entries in the dropdown. I would like it to show only 1 entry. I hope that makes more sense.

[Dmitry Kozlov]

I see. I can recommend you to move medicines to a third list and convert both Medicines fields to lookups.

[Dmitry Kozlov]

Okay, thanks Dmitry. I'll give that a try