Mike,
Ah! Another former-OS/2-ite. Ever hear of Fernwood BBS? To update your Work_orders table whenever you enter parts or labour, you will need to create a trigger on the parts table and one on the labour table. A trigger is nothing more than R:BASE code placed into a stored procedure. You then create the trigger specifying the stored procedure as the code to execute. Go to http://www.razzak.com/fte/ and search on trigger; I'm pretty sure Razzak has a document there. For your report, the easiest way is to create a view that links together your Work_order table and the other two. Presumably on the parts table you have a key field such as part_id which is also found on Work_order. That would be the linking column. A similar link between Work_order and labour must exist. Once you have built your view you base your report on the view. If the view is properly constructed, there will be no duplicate parts/labour entries in your report. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fakaro Sent: Friday, May 09, 2008 4:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - A couple of questions I am a former R:base 5.5 for OS/2 user and am now working with R:base 7:6 for windows I guess my memory is not as good as I had hoped, I am hopeful that someone on this list can point me in the right direction I am not afraid to read and learn so if anyone can point me to the documentation for what I am trying to do the would be great! I have 3 tables involved "Work_orders" & "Parts" & "Labour" 1) I am trying to get a form to update the "Work_orders" table as each line item is inputed in either "Parts" or "Labour". I have a work order form that allows me to punch in parts to the "Parts" table and labour to the "Labour" table but I want the form to add the ongoing totals up into the main "Work_orders" table. IE: the "Parts" table records the items individual cost and the "Work_order" table records the sum of the parts costs. I can't for the life of me remember how I used to do this, I wish i still had my old books!!! In enter mode I am adding rows that include the cost of individual parts or labour into "Parts" or "Labour" at the same time I want the cost of these items added to "Work_orders" on an accumulative manner ...... when I hit [Enter] in the last column in "Parts" or "Labour" I want the form to add the cost to "Parts" and also to add the cost of that part just entered to the total in "Work_orders" so as I enter each part the total in "Work_orders" grows to reflect the increasing totals ..... I can then run a report showing me the totals of "Parts" and "Labour" using the "Work_orders" table 2) I need to make a report based on the Work_orders table that will tally up and list all the line items from the parts table and the labour table. I can easily do it with just the parts or labour and have ....... but trying to get both in the same report has been very frustrating I end up with massive amounts of duplicates ...... I have not done this in the past as I have only had to deal with a single table as is in the R:Base sample databases. I use the "Work_order" table to store the cutomer number, work order number, parts total costs, labour total costs ....etc etc ..... for the work orders, the Parts and Labour tables records just that ..... Parts and Labour linked to the "Work_order" table by the Work order number. I need to create a report that will show all related Parts and Labour to that work order number. I can do this easily with just Parts or Labour but when I attempt to add both I get duplicates coming out my ears. I am thinking it is just the placement of my breaks .... it seems that breaks are nested, I need to list all the labour ..... based on the break being the work order number and then run the parts next ..... breaking again on the work order number. I may not be explaining this very well .... but my head is swimming and I think the way I wrote this magnifies the fact. Looked through the samples but they only show you how to pull items using a single table and a break and I do get that! It's like I need to run the same break twice but on different tables one after the other .... again I can't find any help in the documentation and I know you must be able to do this. Thanks Mike
