Create  Master – Details forms for your MySQL Database  :

subforms in Smart Form Maker

The newest version of Smart Form Maker creates forms in Master/Detail views (subforms). This new option allows you to create relationships and analyze the details of a particular record in a simple, fast and with ease lets assume you have a database with two related tables “customers” and “orders” and  you want to create orders per customer form , in this scenario  the “Master” form should be for the customer’s information and the sub-form should be for listing the selected customer’s orders . Of course the master and details form will be displayed in the same page to help you manage your data more quickly

The process of creating subforms goes in a few simple steps :

1) Start by creating your master form (the customers form in our example) , at  the “Form type” step please choose “Master/details” form

sub forms

2) Once selecting the “Master/details” form type  a new window should appear, using this window you need to define :

  • The data source table of your subform (the orders table in our example)
  • The joining column (the “customerID” column in our example)

3) Customize your sub-form by selecting its columns, labels, validation rules, etc

Other new Form types 

Access your forms directly from your mobile device with no additional effort. Smart Form Maker now has an optimized version for iPhone/iPod touch and android devices, it makes your forms go mobile

Mobile form for mysql