re:calling forms within forms
Date: 14 Jun 1994 19:13:15 GMT
Message-ID: <2tkvgb$nns_at_news.duke.edu>
> I have developed several forms. Some are simple for simple
: > maintenance of decode lists (say department code) and some
: > are more complicated one (say updating staff records).
: > My problem is if I am updating a staff record and find that the
: > department code is missing, I would like to re-call that simple form
: > and insert and commit that dept to database.
: > How can I do this?
We do this in a lot of our forms. What we do is have a trigger that calls the other form. Create a global varibal in form 'A', say 'XXXXXX', then in form 'B' have that same varibal(but not global) set to 'YYYYYY', if the person calls form 'B' have it do a query only if that global varibal is set to 'XXXXXX' which would then only happen if he called it from form 'A'. You have to be careful and do this both ways though as you could get yourself into a loop. If they call 'A' from 'B' they cannot turn and call 'B' from 'A'. Received on Tue Jun 14 1994 - 21:13:15 CEST