Conditional dropdown in embedded report

• Jobs
• Prices
• Costs

• Jobs < Costs
• Prices < Jobs
• Prices < Costs

• Primary
• Secondary
• Primary & Secondary

I have reports  built in the Prices table, one for Primary Type and one for Secondary Type.
If a record has a type of Primary & Secondary, then it would populate into both the Primary Type report and the Secondary Type report.

The Costs form is built so that the "Items" dropdown (coming from the Prices relationship) is based off of the Secondary Type report from the Prices table. Thus when I click the dropdown, it only provides me with a list of Items from the Prices table, categorized with a type of Secondary. It works as it should.

I previously had the Costs table's "Embedded for Jobs" report embedded in the Jobs form. It was editable in Grid form from within the Jobs form. When I would select the Item dropdown in that grid edit Costs table embedded form, it would only show me the items with a type of Secondary. This was the result I was looking for and it worked as expected.

However, I needed to include a number of additional fields in the embedded report and rather than update the "Embedded for Jobs" report, I created a new one called "Costs - Job Form - Add/Edit". I included all the fields I needed and embedded it into the Jobs form, taking the place of the "Embedded for Jobs" report.

In that process, I accidently deleted the "Embedded for Jobs" report from the Costs table.

Yet now, when I am in the Jobs form, and select the dropdown menu from within the embedded costs table (Costs - Job Form - Add/Edit), it shows me all items, regardless of the type. It shows me primary and secondary. It is supposed to only show me secondary.

I have gone back and checked my costs table form. The Items menu is still linked to the Prices table and only showing the Secondary items, like it should.

I don't know what I have done incorrectly and can't seem to figure this one out .....

I am betting that it is something pretty simple, and I would probably catch it if it wasn't close to 1am currently.

Any thoughts, ideas, suggestions, to help make it so that the Items menu from the embedded costs report in the job form, only shows the Secondary types from the Prices table????

Thank you in advance and thanks for taking the time to read my light novel above .....