Marcos - I get exactly what you're trying to accomplish. What I fail to understand is why you need it in a real field instead of a displayed field.
Don On Mon, Oct 11, 2010 at 2:26 PM, Marcos Favero Florence de Barros < [email protected]> wrote: > Hi, > > Although I read the "Using Keep A Total to Update Records in > Foreign Panels" section in Ralph Alvy's book, I'm not sure about > how to handle the following situation. > > In the Inventory Control section of a database, there is: > > (1) an 'Inventory' panel with: > > Item name _______________ > Quantity now in stock _____ units > Cost of most recent purchase $ _____ > > > (2) a 'Purchases' panel with: > > Date of purchase __/__/____ > Item name _______________ > Quantity purchased _____ units > Purchase cost $ _____ > > The 'quantity purchased' field of the second panel is used to > update the 'quantity now in stock' field of the first panel via a > keep-a-total, as usual. > > Now, I would like to have another automatic update here, namely > copying 'Purchase cost' of the second panel into 'Cost of most > recent purchase' of the first panel. This would be similar to > keep-a-total except that the number should not be added or > subtracted, but just copied. > > Is that possible? > > (An accounting note: We need the cost of the *most recent* > purchase because we are going by the so-called LIFO, or Last In > First Out, criterion for the cost of merchandise sold.) > > Here is another way to frame the same question. Suppose we have a > window in the first panel, with a single line, displaying records > of the second panel in reverse order (i.e., just the last record > appears), and showing just one field: 'purchase cost'. This is > exactly the information I want to be in the first panel -- only, > not in a window, but in a real field. > > Thanks, > > Marcos > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
