Claudine, I use temporary tables only to view data or to generate reports as it can speed up the process quite a bit. For data entry I use forms mostly in the EDIT mode and hardly ever in ENTER mode. When I need to enter new data/create new record, I prompt to user to provide some basic information and then I create a new record with this information via code, making sure rules are met, and then display the newly created record so the user can edit it. Makes sense?
Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Friday, September 12, 2014 3:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Form Design Question Hello all, I have recently changed from permanent tables to temporary tables for the main data entry. In order to only have a single form to maintain, I am also using the underlying temp tables for viewing and editing the data. I have apparently created some instability in the design of this form so I intend to re-create it from scratch. I'm curious. What is the most efficient and/or your preferred usage of temporary tables vs. permanent tables to enter and edit data? TIA, Claudine --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
