Update table using non key field
Is there at all possible that we could update a table using a non key field? The contents of the table are such that I could have one key field to deal with certain number of records maintained by us...
Forum Discussion
When updated by using an API or via importing records, the only two fields which can be used to identify which record to be updated is the [Record ID#] field and the Key field. A table starts out with the Record ID field being the Key field, but the Key field can be changed to another unique field.
If users are updating records manually then they do not care or need to understand what the key field is. So set the Key field to be the one which is being updated by imports or APIs. Note that many types of fields can be set to be unique in order to prevent duplicate s during data entry by users,
If users are updating records manually then they do not care or need to understand what the key field is. So set the Key field to be the one which is being updated by imports or APIs. Note that many types of fields can be set to be unique in order to prevent duplicate s during data entry by users,