After the recent updates to Sc I now get an error when trying to create a new record.
When creating a new record the “OrderID” doesn’t get created untill the record is saved and the mySQL creates the auto increment id #.
This error i’m getting has something to do with the “Multi-Upload” field as its looking for the foreign key which is tied to the “OrderID” which hasn’t been created yet in a new record untill its saved.
Like I said I didn’t get this error before but it kinda makes sense because its referencing an Primary key that doesn’t exist for that record yet.
How can I fix this?