Board index » jbuilder » Hierarchical Lookups
2003-11-13 04:29:15 AM
Imagine two tables with the following fields:
MAIN: ID, FLD1, FLD2, ...
LOOKUP: ID, FLD1
The values that are legal for MAIN:FLD1 can be any value in LOOKUP:FLD1, as
long as LOOKUP:ID is equal to the current value of MAIN:ID.
It seems like you should be able to tweak the lookup jdbQueryDataSet to be
parameterized by the main table jdbQueryDataSet using the "ID" field as the
parameter, and then setting up a master/detail link in the lookup
jdbQuerySet. However I keep getting "Operation not allowed on empty null
Any clues greatly appreciated. Thx.