Re: Advice on debugging SQLforms (triggers?)

xanmj_at_levels.unisa.edu.au writes:
>
> I have a master-detail relationship where the field which joins
> the two is not "visible" in the form. There is an additional complication
> in that there is a reference (copy) of one of the detail block's fields.
>
> The intention is use the referenced, detail field on the same page
> as the master block, presenting the user a screen containing the master block
> information and a single field from the detail block. If the user wants more
> information on the detail block they can bring up the detail info. in a popup
> window.
>

Why use a referenced field? If want to see only that field then trying using a temp/dummy field (non-database). Either that or create 3 blocks. The second block should have the detail field on the master block and the 3rd blk should have the detail fields you want displayed. You shouldn't have any problems making the 2nd block field as not editable so when you insert data you would be commiting on blocks 1 (master) and 3 (detail-detail).

Hopefully I've understood your problem.

Mike. Received on Mon Jul 19 1993 - 18:31:37 CEST