Hi
I'm trying to understand the differences between creating 'Form on a SQL Query' and 'Report with Form on Table'. I know that you have to setup certain items manually using 'Form on a SQL Query'. I want to be able to use the front end form to insert, update, delete and cancel for the DML, just like is done automatically with 'Report with Form on Table'.
The Cancel button is the only one showing, although the buttons Create, Save and Delete are created automatically. As an example, for the Create button, the Database Action is set to SQL INSERT action on the Submit Page action and it will only operate when the Item IS NOT NULL, that item being the P13_CUSTOMER_ID:
The three buttons are still not active however and I'd like to know how to unhide them/make them active? I can't see any Enabled/Visible type of property to do this in the Property Editor.
Regards,
Michelle