Greg: Just locate a grid for the tables on one side of your form, with just a couple of columns (say store number and name) and then, on the other side, locate all the detail columns/fields for that particular store. As you navigate up and down the grid, you will see that the data on the detail side will show the corresponding data. If you have the conference CD, you can look at my presentation to see how I do it. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Greg Miller Sent: Wednesday, February 23, 2005 12:55 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Changing Form Content I am trying to create a form that contains all data pertaining to a particular store. Each store has a number. When I change the store number, I want to update the form to display the new store's number. Previously, we have always used a menu to select a store, which passes the store number to a form with "edit using... where...". Unfortunately, many of our techniques date to 2.11 and need serious updating! Since there are data navigation controls available now, I am sure that this is possible but I can't figure it out... Also, the way I want to select the store is with two fields and a grid. As the user enters either the store number or the store name into either of the fields, the grid will walk to the appropriate loaction (showing store number, store name, and store state). Has anyone done something like this? Thanks! Greg Miller
