>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")
Please ignore the previous this message, I'm going to reposte it in an easier way, maybe I wasn't clear enough.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould