April 8, 201411 yr Hi, I have small issue. I have created to 2 tables. Payments and PaymentLine. Payment is parent and PaymentLine is child. Payment has 2 fields. ID and Date where as PaymentLine has fields amount category note and check no. I want to create a list of all Payments Records they occurred in one month and total amount. I created a Summary Field in PaymentLine table and made it total of Amounts. But i perform search using a Perform Find. I don't get the total of the month. Instead i get total of all the records. What i am missing? 08-Apr-2014.zip
April 9, 201411 yr Change the layout setup to show records from 'Payments_Line' table rather than the 'Payments' table.
April 11, 201411 yr Author Change the layout setup to show records from 'Payments_Line' table rather than the 'Payments' table. Thanks it worked.
Create an account or sign in to comment