No Record on the 'one' side

[Guest]

I have a form that prepares data for an invoice. The form is linked to it's
own table "UnitSales" and is populated from a table called "TCA" the invoice
report is then generated primarily from the "UnitSales" table. Both tables
link to a third table called "StockUnits" containing information regarding
the unit to be sold.

Recently I have added fields to the UnitSales table to facilitate
denormalization to speed up query times and reduce locks on records over
multiple tables as this is a multi-user system. I now get the error:

"Records in table 'StockUnits' would have no record on the 'one' side"

Where do I start looking for the error?

Thanks,

Pip''n

 

[Guest]

I have a form that prepares data for an invoice. The form is linked to it's
own table "UnitSales" and is populated from a table called "TCA" the invoice
report is then generated primarily from the "UnitSales" table. Both tables
link to a third table called "StockUnits" containing information regarding
the unit to be sold.

Recently I have added fields to the UnitSales table to facilitate
denormalization to speed up query times and reduce locks on records over
multiple tables as this is a multi-user system. I now get the error:

"Records in table 'StockUnits' would have no record on the 'one' side"

Where do I start looking for the error?

Thanks,

Pip''n

The error occurs when this line of code is run:

' enter stock #
Form_UnitSales.STK_ = Form_TCA.TCASTK_

the error says:

Records in table 'StockUnits' would have no record on the 'one' side.

The value is taken from the TCA Form that opens the UnitSales Form. The Code
occurs in the OnClick event of the button that opens the form.

Pip''n