Is it possible to have a one to one relationship?

[sales_bikefix]

I am trying to make something like a cash register to capture transactions relating to jobs (Its a shop).

I use LINKTOVIEW to set a transaction record but I would like to be able to see the “amount due” in the original jobs table. I know I can show a REFROWS list, but since its only one record I just want to show the amount.

I want to use a separate transactions table as I want to create permanent records from the calculated fields for the purpose of keeping records and I want to separate out cash from card payments.

[Aleksi]

One way is if you use Job’s key column value as transaction’s key value.