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
