Is your layout in form view? This will only show one record at a time from the layout table.
Typically you would use a found set (rather than omitting) and a layout in list view.
The larger the body of a listview layout the more space is given to display the records you might want to check how much "extra" body you have in the layout.
Report layouts can take on a lot of different looks.
Why do you have Omit multiple records in this script?
Assuming that gIDItem is your dropdown list field and it's a global field with this relationship:
YourTable::gIDItem = IT_Items_Self_gIDOrg::IDItem
and YourTable, IT_Items_Self_gIDOrg are table occurrences of the same data source table as the names indicate here...
THen you only need the Go To Releated record step and it will pull up a found set of all the records where IDItem matches gIDITem.
No need for the omit record/show only omitted--which is one method for isolating the current record in a found set of 1 record (but can fail in networked environments).
Thanks Phil, I've got that to work.
However, is there any way of filtering other records which are not specific to that publisher? At the moment I've set the script to:
- Show all records
- Sort records [Restore] // sorted by Publisher
- Go to related record [from table: "IT_Items_Self_gIDOrg"; Using Layout: <Current Layout>]
Can you give an example of what you mean by this? (There's lot's of different ways I could interpret "not specific to that publisher".)
Apologies for my ambiguity.
For example, when I select "Addiction" as Publisher, the report correctly sorts the records by Addiciton, however other records are still listed within the report (please see attached screenshot.) Ideally I'd like only records from the selected publisher to be visible when filtered by the dropdown menu.
That said, your script should only be pulling up records with "Addiction" in the publisher field if your relationship is correctly defined here. The other records should not match and should not appear here.
If "Publisher" is a text field. You first need this relationship before Go TO Related Records will work for you:
LayoutTableOccurrence::GlobalTextField = 2ndTableOccurrenceOfSameTable::Publisher
Global text field must be a field of the same data type as publisher, but with global storage.
Your script would simply be:
Go to related record [Show only related records; from table: "2ndTableOccurrenceOfSameTable"; Using Layout: <Current Layout>]
(The sort records step you used doesn't have any purpose here.)