Dynamic List Items in Forms 4.5

I am trying to figure out how to set the list of items that appear in a list item. Because I don't feel I have explained this sufficiently, I will give an example.

I have a "country" field and the options are Canada or United States. The next field is "State/Province", if Canada was selected, I would want to pull out the "list item" and the "list item value" from another table based on a sql search triggered by leaving the country field.

Is that clear?

I know I could use an LOV pop-up (but this is another modal window which I am trying to avoid), but I would really perfer a list item.

Thanks,
Dan
dstern_at_ctp.com Received on Fri May 30 1997 - 00:00:00 CDT