I know I can do the 2 table scrolling but I want to create a temp table or view so I can list the last time a person paid all in one form. eg create table with col (phone,name,paid date,amount) I can't figure out how to load paid date and amount with the max date(which would be the last date) Tom Hart
________________________________ From: Emmitt Dove <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sun, January 23, 2011 12:41:34 PM Subject: [RBASE-L] - RE: Getting data into a table Tom, There are two ways, both simple. 1) Create a form with your customer table as the main table, and the transaction table as a slave table. The important thing to remember is that the two tables will link on all common columns. Put the customer information in one scrolling region and the transaction information in a second. The transaction scrolling region will change to show all transactions for the customer selected in the first. See Razzak’s examples in his various RRBYW databases. Look for the examples of invoices. 2) Create a view to join the two tables and base the form on the view. Emmitt Dove Converting Systems Architect Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From:[email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Sunday, January 23, 2011 13:31 To: RBASE-L Mailing List Subject: [RBASE-L] - Getting data into a table I have 2 tables: Table1 has customer information like: phone, name, address Table2 keeps track of each time customer has a transaction: phone,amount,date I want to generate a form where I can have a list of the last time each customer paid, with the amount paid. I know there is a simple answer to this but I'm brain dead right now. Tom Hart
