Hi

Using FM8.5 Add.

I have a file with three tables, Contacts (Customers Names etc), Invoices
(The Invoices), Items (Items to be put on the Invoice).

These three tables are related in the following manner.

Contacts file via field 'con_ref' to Invoices file via field 'inv_con_ref'
Contacts file via field 'con_ref' to Items file via field 'ite_con_ref'
Invoices file via field 'inv_ref' to Items file via 'ite_inv_ref'

I am experiencing a problem when it comes to printing an invoice. I have set
up a script to go to the report layout (with show records from option set to
'Items file') and print the invoice and the although the data for the
contacts file is the correct data and so is the items file data, the Invoice
file data is that of the first invoice sent to that contact.

I don't understand why the wrong invoice data is being printed with the
correct contact and items data, when the items records are related to
another invoice belonging to the same contact.

Hope that all makes sense!

--
Jeff Wright

Jeff Wright <jeff (AT) jeffwright (DOT) demon.co.uk> wrote:

Skip the first relation. The relation graph must not go in circles.

The relation you want will still be there as invoices are connected to
contacts via the items.
--
http://clk.ch

Hi

Thanks for the help. I understand.

I'm always walking round in circles!!

--
Jeff Wright

"Christoph Kaufmann" <clk (AT) freesurf (DOT) ch> wrote