Forms 3.0.16 Caution message
Date: Wed, 29 Dec 1993 21:10:13 GMT
Message-ID: <qN9BFc1w165w_at_sytex.com>
Forms 3.0.16, DBMS 6.0.36
Setup: Block 1 is "master block" w/ 6 fields. The types in a value(s) in any of the fields and executes a query. This block is used to look up a customer id for use in Block 2, "detail block". When the right customer is found, the user hits NEXT_BLOCK. The cursor goes to the next block, does an EXECUTE_QUERY and can find multiple items used by that customer. This block's table is a view. Some of the fields in this block are coded, so the code is looked up and "expanded to english" (like translating the code CA to California) and displayed in a non-database field. These two blocks are on page 1.
With the cursor in block 2, the user moves the cursor to the record (8 are displayed) they want more details on and hits a F key which goes to another block on page two.
--- sullivan_at_sytex.com (mike sullivan) Access <=> Internet BBS, a public access internet site Sytex Communications, Arlington VA, 1-703-528-4380Received on Wed Dec 29 1993 - 22:10:13 CET