I had posted this problem before but I am still having problems. I have a set of products with associated options taken from a master list and put into a lookup table.

I am trying to create a line item page where I select the product from a dropdown, and just those options associated with Product A come up in a portal. From there I want to be able to specify, for example, 4 of Option 1, 0 of Option 5, and 1 of option 12 for Product A.

I was thinking that it would be done in a portal, but I'm wondering if the lookup table isn't somehow prohibiting me from doing it.

Any help would be greatly appreciated. No books or examples I have found seem to cover what I am trying to achieve, which leads to believe that either I'm doing something so complex that it's never been done so far, or that I'm doing things completely bassackwards, which is the one I'm going to go with.

Hi spk, i hope my advice doesn't conflict with the previous advice you were given, but here goes:

Your drop down field is called Selecter. Make a relationship from Selecter to Products::Product Name. Now create a portal which uses that relationship and display the options in that portal. Does that do the trick?

HTH

Jerry

I've had a thousand other projects intervene so I haven't had a chance to try this yet. I will update with my results when I finally take this off the back burner.