Have grid edit Dropdown menus show only certain items

Question

I am stumped and need a little push in the right direction.I have a Prices table that is comprised of several different Items.Each Item is either a Primary, Secondary or both Primary & Secondary.The Options field (where primary & secondary is indicated) is a Multi-Select Text field.

Within the Prices table, I have two reports:

Primary Items

Lists all items that are categorized as Primary

Secondary Item

Lists all items that are categorized as Secondary

I have a Costs table which is a join table between Prices and Jobs.The Costs table was generated prior to the Primary & Secondary Items reports being created in the Prices table..The Costs table is a Grid Edit in the Jobs form.

Within the Costs grid edit, I would like the "Price - Item" list (dropdown menu) to only list items from the Secondary Items report.I thought I had it properly set up in the filters, but it isn't working.

Any thoughts?------------------------------Andrew------------------------------

AndrewFry · Answer

Ok, so after re-doing the relationships to ensure I had it done correctly, and re-doing the reports, I came to remember that the filter in the join table grid edit is to SHOW Secondary Items already input, not show only Secondary Items as options. I knew that but didn't remember.

I think that I might have to generate two different Prices tables: Primary Prices, and Secondary Prices, then build my join table off of the Secondary Prices table.

I don't know why, but something rubs me the wrong way about doing it like that. It doesn't seem like the best way to accomplish the end goal.

There has got to be a way to have only the Prices table, which lists the Primary and Secondary items, then have the Join Table (Costs) only list the Secondary Items from the Prices table.

But it currently escapes me.

------------------------------
Andrew Fry
------------------------------

Sign up

Login to the community