Php application for inserting updating and deleting record
See the script in the "Database" script object in the sample form for more details on how to specify this.
Use the Hierarchy palette to locate it under the root subform.
I never use the ID field for lookup, because my application is always based on working with the Name field. I'm using the following trivial SQL code: The bigger the table (number of and size of columns) the more expensive it becomes to delete and insert rather than update.
now the next step is record displaying along with image, well using bootstrap it easy to create an image gallery let's have a look at the script.The side-effects are creating indexes, managing constraints and renewing privileges, but it is worth considering. You have defined a primary key, it will likely automatically become a clustered index (at least SQL Server does so).