I've got a problem and I can't quite seem to figure out how to fix it. I've got a custom table with multiple fields on it. Two of the fields are Market (u_market) and Branch (u_branch). This is what a sample of the data looks like in the table
In the catalog item that I'm working on I've added the Market (Market) field as a reference to the custom table. I've also added the Branch field and that value needs to be dependent on the Market value. No matter what I've tried, I can't get the Branch to display just the values for that market. So if I choose Chicago as the market, I see all the values for the branch, not just Peoria, Greenbay and Chicago.
Like I said, the branch(sls_branch) field on the form is a Lookup Select box to the custom table.
When everything is all said and done, I should be able to choose Chicago from the market and then have only the branches for Chicago display and I should be able to choose one of those.
Any help is greatly appreciated
