>Thanks mark for replying
>
>Warning: The key defined by the KeyField property for table QorM is not unique
>
>How to get rid of this warning message ?
It means what I explained. YOu run the risk of updating multiple records if you issue a TABLEUPDATE() on the view if you make any changes. Since the KeyFields do not uniquely identify a record, you can have more than 1 record that match the data values in the fields you have selected as Key.
I am guessing you are only getting that warning at design time and not when you are trying to use the view and running test updates. I know of no way of getting rid of the message. If the possibility of updating more than one record is unacceptable, you will have to either add more fields to the key list to ensure uniquenss or you will have to add a new field that you populate with a primary key, preferrably a meaningless integer field populated with sequential numbers.
Mark McCasland
Midlothian, TX USA