I've been working for several hours on trying to retrieve the String value of a record that I am accessing via a lookup field, but I cannot seem to figure out how to do it.
Here is the script I'm using:
- RepresentativeItems = (Products1[Representative == input.Representative1.toString()].ID).getall();
Basically I want to be able to populate a subform with all of the product sales by a representative, which I will select from a drop-down list, as you can see in this photo:
My problem is that when a name is selected from the Representative Field it is handed off as the record ID number in my script. How can I get it to hand off the actual Representative name? Using the toString() operator just simply converts the record ID number from Long to a String.
Any assistance with this would be greatly appreciated. I've been working all day on this so the solution is likely very simple and I'm just too tired to realize it.
Thank you!