You are obviously showing the industry name in your list. Saying there is NO industry data available does not seem to be true.
Is this a list view or a portal?
The records are in list view. I meant there is not industry data in the Product_Lines table, other than indirectly by linking with the Accounts table.
If I read this correctly, Once you have selected a product, you want to see a list of all accounts that have a link to that product? I'm not sure from your post, which TO is the basis for your layout and which data source table is specified for the "value lists" TO, so I am going to use my one names, but identify the data source tables in hopes that you can then replicate this design in your system:
Your layout is based on a join table linking products and accounts if I understand correctly. I'll call it Product_Lines as you did originally. For the conditional value list that you describe, all you need are two occurrences of this table:
Product_Lines::ProductID = Product_Lines|SameProduct::ProductID
The left TO is the one specified for your layout. In value list set up, specify the right hand TO as your source of values from your value list and select Product_Lines|SameProduct::AccountID as your first field. If you select "Include only related values starting from Product_Lines, you'll get a list of AccountIDs for those accounts that are linked to the same product as you selected in your first value list. What you show in the second field will depend on what fields you have. You may need to link in another TO of accounts to Product_Lines|SaemProduct so that you can list a description or name field from this added TO of accounts to get a name listed with each account.
For more on conditional value lists you might be interested in this free instructional file:
This file has multiple working examples of different ways to set up CVL's with detailed documentation on each.
Thank you, that worked fine and thanks for the example file I will go through the file. Took me a little while to figure out how to lay a field over the Acct ID drop down. I didn't want to show the Acct ID and Industry after they were selected, only show the Industry.
I didn't want to show the Acct ID and Industry after they were selected, only show the Industry.
Laying a "label" field with browse mode access blocked over the drop down is a commonly used work around. However, if you selected the pop up menu option, this trick is not necessary.
I saw the Pop up menu option solution last night as I was going through your example file, thanks again.