That sounds very similar to what I did in the post below, but instead of using a form to write a new record to the temp table and then transferring that info to another table, just use the temp table with user specific columns to accept the inputs, then let it check if there is a match through a single relation. If the relation is empty, then add a new row to the table. If the relation is not empty, then update the existing row through the relation.
3 Likes