When i try to update field in a related table with two foreign keys (set as primary keys) i get this message.
"error": [
{
"context": null,
"message": "Failed to update many to one assignment.\nRelating records with multiple field primary keys is not currently supported.",
"code": 400
}
]
}```
The related table has two keys, one timestamp field and one "comments" field
I would like to be able to :
1: update timestamp and comment field for old entries
2: create new entry if there are none of that kind there (meaning key1 and key2 are not there)
so how can i do this?
Server side or API, does not matter, as long as i can get it done ;)
EDIT: I have full access to the MSSQL server but i can not change the schema, i can make custom functions if that is needed also.