Polychronis: A pop-up can be configured in many ways; you can display more that one field and return to the column a value that is not even displayed if you want to do so. For example, you might want to select an employee ID but you can have your pop-up display unique values for the employee Last name, First name and pay rate and when you select one employee it will return his/her employee ID (which was no even displayed) you can also format the pop-up display by using the LJS or RJS or any other function and you can also change the colors and fonts of the displayed data and titles; all in all a very powerful utility. I also use speed buttons that display list of selections using the CHOOSE command, which again you can manipulate in any way you want; once you select an option and retrieve whatever value you need into a variable, you can then update and /or manipulate all the other columns in the record using the UPDTADE or PROPERTY commands and then refreshing the display using the PROPERTY TABLE your_table 'REFRESH' command. Please let me know if you need examples and I can send you some screen shots of pop-ups I use with their corresponding set-up. 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 ELOEN Sent: Tuesday, September 27, 2005 12:42 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Refreshing multi table screens Javier, Sorry to come in this thread like a comet, but as a newbie to win Rbase (for the last 5? years) I try an application that is close to your thoughts. As a matter of fact any application in a dbms contains a form that handles 1:m rel tables. How do you manage for example the lack of combo boxes in a region? I 've tried the pop ups as an alternative with no acceptable success. For example RRBYW8 uses a code field to popup, but in my buiseness reality no one wants to use and see codes, only descriptions. How do you accomplish this? I'm impressed of the new things Win Rbase accomplishes but I have an impression that this 'basic' handle of 1:m rel tables is yet not fully functional in forms. I mean you still need tricks to handle such a basic need in dbms? I will be glad to be wrong. TIA Polychronis ________________________________ I know that some user like to add the data to a temporary table and the transfer it to the actual table. I prefer to use the actual table; however, I always use speed button to add and delete rows using code rather than the insert, delete roe native functions. For example to enter a new row in a sub-table, I prompt the user for some minimum data, add some default values, insert the data into the table and then use the PROPERTY ..'REFRESH' to update the form; it work beautifully. New records to them main table are always added with code outside of the form and the then the form is opened in the EDIT mode; as I said, I do not use form in the ENTER mode at all.juts a personal preference that has serve me well.
