Hi, all.
I have a problem that is vexing me a great deal.
My simple table is connected to a form. There is a PK, which is NOT IDENTITY generated.
My Form is ALWAYS passed a valid PK, and if the value does not exist in the table, then a NEW record is created as expected.
However, if the value does exist in the table, then the values are NOT being collected back into the form, and therefore the save on submit is also failing.
My Processor is Init, and I have also tried using ARF to no avail.
FWIW, everything works as it should of course if I change the table to make the ID Autocreated, but this is not how this must work. I have to seed the value for NEW records (which works) and use the same value to look up and edit the table - which does not.
I hope someone knows the answer, and can assist. I obviously havent "tried everything" (yet) or it would be working - but I have spent a huge amount of time trying the wrong things :-(
George ...