Hi, I am working on developing a form that allows users to choose packages from a dropdown. While the package names are in the dropdown, I need to have a table embedded in the form that displays what items are in the packages, filtered by what package(s) is/are selected. The table with the items do not need to be saved, as that data exists in a separate Master file, but it needs to be shown so the user can see what is in the package(s).
The one to many relationship seems to throwing things off, and I haven't been able to find a filtering technique or workaround using multiple forms that has been successful. The Filter Control function does what I am looking for, but there is no way (that I know of) to save the package names the user selects in the filter, which would require them to enter the same thing again in the main form's package field. This is not ideal from a usability standpoint, so if anyone knows a solution or workaround, I am all ears! 