So if I chose an item on my gallery (a SQL view of table 1 and table 2 linked on unique ID)
I want my default values to be kept in the 'Edit' (this would be anything from table 1)
But I have a linked table with additional comments on the first table
But when I go into my edit, I want this component to be 'new' as whenever I edit I want this to be new (so anything from table 2 in edit mode is actually blank)
My form will be a SQL view connecting table 1 and table 2
IS this possible to do?
Please and thank you