Hello all you Guys,
Lets say that I have three tables:

fruits supliers vendors
fruit_code<----->fruit_code vendor_name
fruit_desc vendor_code<------>vendor_code
vendor_avail

between fruits and supliers exist a one-to-many
relationship, because a fruit can have many supliers,
between supliers and vendors exist a many-to-one relationship, because every vendor has just a name,
got it?
then I created a form with my parent table "fruits",
and added a grid, the grid RecordSourceType is set to alias, and the RowSource is set to a view named Fruit_vendors, this view shows the vendors names for
each fruit and whether the vendor is available or not,
that is, it shows two columns with vendors.vendor_name, supliers.vendor_avail, each fruit can have more than one
vendor available, the grid has a CheckBox in the vendor_avail field, every time that I change this field
in the grid to set a vendor available or not I receive this message "Warning Keyfield is not unique in supliers", of course is not unique, because a fruit can
have more than one suplier, and then it replaces all the
records in supliers with the new value, how can I just
update that one record and avoid this by changing the
value in my grid.
=THIS.thanks("in advance")