hello world,
i have two tables stock and sales where one to many relationship is
created. The join type is " 2: include all records from stock table
and only those from sales where the joined fields are equal." when I
created the update query and wanted to subtract the qty sold of sales
table from the balance field in stock table, I am not able to do so.
The error I get is "did not update due to any one of the following
reasons: conversion failure, key violation, due to lock violation,
validation rule violation".
If I try one to one relationship I am able to update the balance field
in stock table.
The datatype are same, no validation rules are given for the fields.
But in query all records are locked. Can you help me to solve this
problem?
Thankyou,
W.R.Stephen
i have two tables stock and sales where one to many relationship is
created. The join type is " 2: include all records from stock table
and only those from sales where the joined fields are equal." when I
created the update query and wanted to subtract the qty sold of sales
table from the balance field in stock table, I am not able to do so.
The error I get is "did not update due to any one of the following
reasons: conversion failure, key violation, due to lock violation,
validation rule violation".
If I try one to one relationship I am able to update the balance field
in stock table.
The datatype are same, no validation rules are given for the fields.
But in query all records are locked. Can you help me to solve this
problem?
Thankyou,
W.R.Stephen