At a loss. Trying to build a command query in Crystal taking the sequence plus one to get the linked entry. It seems you cannot calculate in a Crystal query against a key/index field??? I can apply the same logic on a numeric field that is not an index and everything is just fine. I need to take bank transfers and just show the transfer to. Best way is to build a command for the out and in but increment the sequence and then link run and sequence number. I hate the messy subform variable pass so was hoping it would be possible with out it. It seems you cannot calc on the index because I did try with another table and got the same errors. Yet  you can do the calculation pulling the SQL data or by making a formula in Crystal.

Grrr