emotionuk

Hi, I was just wondering what everybody considers best practice in the following scenario: In layout 1(table:invoices) on record 10 Go to layout 2(table:customers) and perform some finds and some field updates Return to layout 1 # IS THE NEXT STEP NECESSARY? Perform find (record 10) When we return to layout 1, do we need to perform a find to make sure we are back on record 10, or can we rely on Filemaker to take us back to the last record on that layout? It just seems that there might be an performance advantage in leaving out the find if you have a lot of records. Thoughts, advice needed! Thanks, Christian

Matthew, thanks for the reply. Could you give me an example of how you would populate the transaction table using the data from the other two tables? For example, if I make a relationship between the "Suppliers" table (which contains the supplier's details but no credit or debit information) and the "Invoices" table (which contains the debits) and the "Payments" table (which contains the credits), then the "Suppliers" table contains 100 records (our suppliers), the "Invoices" table contains about 1000 records (our debits) and the "Payments" table contains about 250 records (our credits). How can I pull them all together in one report in Date order? I don't think that using the supplier's ID as a relationship is enough... Do I need to script some sort of automatic table populating so that when you press a "report" button it pulls all that info together in a separate table? If so, what might that look like, and how do I stop loads of erroneous populated tables from hanging around? Thanks again everyone!

Hello, I am trying to create a bank statement-style report of a supplier statement. Basically, the statement will contain four fields from three related tables. The fields are: Date, Credit, Debit and Balance. One table is "Supplier" which contains a unique supplier ID, the next table is "Invoices", and the final is "Payments", all linked using the unique supplier ID. So, the data is stored like this: Date(Both Invoices and Payments table), Credit(Payments table), Debit(Invoices table) and Balance(summary field). But, I can't figure out how to get the information from the Invoices and Payments tables to show on my report. I have tried creating a new table called "Supplier Statement" with the correct calculation fields, but this table contains 0 records, so I don't know if I need to perform some sort of scripted import from the other tables? Or maybe I am just being really stupid and missing something simple? Thanks all in advance, Christian.