Report dropdown menu filter (omitting other records)
I'm trying to create a filter script that will allow me to filter records in a report layout using a dropdown menu. This is for a stock inventory database where I wish to filter records based on the publisher field.
I've attached an image to show you the script I've got so far. This script filters the records successfully, but only shows the first record for the publisher. However, I'd like to show all the records pertaining to that publisher!
Any help would be greatly appreciated.
BTW I'm using FileMaker Pro 10 Advanced