Hi!

Kay is an unique identifier of the record in the table. Value of this field or these fields will be used in the command like

UPDATE .... WHERE KeyField1={current record value} [ AND KeyField2={current record value} ...]

>Hello All,
>
> Need an explanation on the key field definition. Is the key an image of your indexes from the table and can you have more than 1 in a view. What if an index is made up for two fields. Based on what sort my user is choosing I need to replace records based on how they found the record so my index could be different for each user? How would I handle a replace using the view. I have checked off all the fields which are part of my indexes is this the correct way. Any good books to help me understand using views?
>
>TIA