Hi there, thanks for the reply. Here is where I am at with a couple questions.
I have created the relationship between the two tables I am hoping this is correct: The table "Picks" is where the actual form that gets filled out resides. The "Brands" table is where the records are to populate the dropdown fields.
Currently I am able to display a "Related Brand2" field that displays the records from the "Brands" table. However, I do not know how to filter for the records that are either 3% or 5%.
I have created two reports in the Brands table that are the following:
I do not know how to apply this report to a field to filter out records that are 3% or 5%.
