[RBASE-L] - RE: Prefilling a form

[Bill Eyring]

Hjortmar   Not knowing the details of your business I can suggest a few things that might get you pointed in the right direction.   You might try this:   When you take a menu choice of Enter New Order, enter a custom EEP that inserts the needed 8 rows from the articleregister into the tOrderdetail table and then edit using the form.   With the paper I would suggest you create a lookup table for PaperInventory. For the Group2 line put in a pop-up list to change paper on the fly. If you need multiple lines of paper then use it (the paper lookup table) in the second part of the form.   You might also add a button on the form that 'Add a Detail Line'   Other Suggestions: Create lookup tables for use in the JobTicket form so you can; Popup prices based on customer type Popup paper types Popup how paper is put together   You get the idea.   Good luck   Bill Eyring Director of Information Systems Michael Haberman Associates, Inc. 125 Front Street, Mineola NY 11501 516-739-8080   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hjortmar Christian Sent: Friday, October 01, 2004 9:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Prefilling a form At the time I am using Salesform, (a two table form in Part 8 of Running R:base your way), as an inspiration for filling in a “Jobticket”. What I want to do is having 8 rows of “orderdetail” prefilled with rows from an articleregister table. It should be easy enough with APPEND articleregister TO tOrderdetail. The rows are in the tOrderdetail table alright but I only get one empty row in the form. That is the APPEND command is issued in the eep that starts the form. If I do the APPEND from within the form entering a new row then I would APPEND over and over again.   I work at a printshop. The purpose of filling in 8 articlegroups are to make it easier and not to miss anything when we fill in a jobticket. Group 1 is a starting fee. Sometimes we don’t need that. Group 2 is choice of paper. Group 3 is about how to put paper together, staple and so forth. Group 4…,5…,6…,7….,8… These groups also define how to charge.   The second group, choice of paper, can be repeated, depending on if the job needs extra paper in the job. So it’s a kind of entering and editing at the same time.   I would be grateful for anything that points me in the right direction of prefilling two table forms.   Regards Christian Hjortmar Kopieringscentralen Universitetssjukhuset i Lund