Lookup of a Lookup

[amypaulsmom]

I am trying to get a client ID field to show up in my line items database from by clients database, with an invoice database inbetween.

Within the Invoice Entry the client number is pulled from the client card. Then on the line items card - I am trying to get the client ID to come up again from the invoice card.

Essentially - I am trying to do a lookup on a field that is already using a look up to find itself. Is that possible??

[Korky]

You say that the client number is pulled from the client record.

Surely the Client number (ID) is typed into the invoice and the other client details pulled from the client record?

If I'm right, all you have to do is to create a "reverse relationship"

from your Line Items to the Invoice file using'Invoice ID'as the match field. Then add the related field 'Client ID'to your Line Items layout.

[amypaulsmom]

That is what I have done. I changed things around a little. I actually export the invoice (into Posted Invoices DB) and when it is imported the client ID is imported. Then I have a relationship set up between the Posted Invoice DB and the Line Items DB. The Client ID field in the Line Items is pulling from that relationship via a look-up. But nothing appears. HELP - I really need this Client ID field to show on my Line Items DB - so that I can get a account balance calculation to work right.

Thanks!!!!

[amypaulsmom]

Got it to work - am pulling the account balance calculation from my posted invoices file and total purchse price rather then the line items file!

YEA!!