Shape Data: Multiple DB lookups

Started by chris.williams, March 12, 2012, 07:57:29 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

chris.williams

Hi - I have a need to assign data to a shape based on a DB lookup of previously entered data.

Example:

A shape has four data rows that need to be entered.

  • The first row should be a drop down list from a linked DB
    The second row should be a drop down list based on a filtered criteria from the first row in the same DB
    The third row should be a drop down list based on a filtered criteria from the first row in the same DB
    The fourth row should be a drop down list based on a filtered criteria from the third row in the same DB

All of these data points should be prompted for when the shape is dropped on the page.

Is it possible to have a custom drop down list for each field in the Shape Data window as it is opened when the shape is placed on the page?

How would one go about setting the "Value" attribute of the data row within the ShapeSheet tools menu?