Create a tableColor Rule:
Table Design Rule |
|||
Name: |
tableColor |
Special Instructions: |
|
Type: |
any |
|
|
Flags: |
cached, parameter |
Category: |
|
Formula: |
[default] |
||
Add a dimSet Rule:
Table Design Rule |
|||
Name: |
dimSet |
Special Instructions: |
|
Type: |
integer |
|
|
Flags: |
cached, parameter |
Category: |
|
Formula: |
[default] |
||
In the formula for tableColor, enter the following code:
child.getRows( "SELECT * FROM Color" )
Note that it is "getRows" plural. This returns an array of rows from the database. Check the result in the Immediate window.
Change tableColor's formula to
child.getRow( "SELECT * FROM Color" )
Note it is "getRow" singular. This returns a single row from the database. Check the result in the Immediate window.
