I have a table of advertisers. Each one is assigned to a specific market. When a sales rep enters a new ad for an advertiser I need them to be able to only see their market. Example:
User selects Enter New Ad.
1) Form is presented and user must Select Market and submit ->
2) The next form should only show those advertisers within the selected Market from above.
3) User selects advertiser and is presented with Enter Form ad (advertiser pre-populated from step 2 submit).
How do I accomplish step 2? I know you can do pre-filters on Table views but these are forms.
User selects Enter New Ad.
1) Form is presented and user must Select Market and submit ->
2) The next form should only show those advertisers within the selected Market from above.
3) User selects advertiser and is presented with Enter Form ad (advertiser pre-populated from step 2 submit).
How do I accomplish step 2? I know you can do pre-filters on Table views but these are forms.