Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

Freefields plugin - Create freefields a more complex example

Article Index

Page 3 of 7

Create freefields a more complex example


We will now take a more complex example. A new one to many relationship for a debtor. Here we create fields for the date and a memo field for the call.

Click the Add button and enter the following information.

  • Formname: An internal name must be unique.

  • Displayname: The name used for this tab. You can have multiple tabs with a single entity. this may then also contain a variety of relationships.

  • Master table: The table to which this free fields are linked. When creating it is also used for reference integrity.

  • Linked key: The key used in that table (primary key)

  • Table: If this does not exist it will be created.

  • PrimaryKey: The Primary key for a one to many relationship like this can be linked to the key for a one many will own generator should be used.

  • Sql for next id: For one to many using the text "select GEN_ID (GEN_TESTID 1) from RDB $ DATABASE" as in the picture above.

If it's a one on one relationship space (dummy value) can be used to observe the linked key. Primary key equal

If you have done this, press Save. A confirmation message to create the new table will be displayed.

You get that whether you want to create this table. Press Yes to add the table. The new fields this You can also select No hence, your input is not lost and you will be given the choice to create the table next time.

If the table is created, we can continue to add new fields by clicking the "Edit fields" button or double-clicking the name in the list.


To add the next control and enter the following:

• Type of control: D TDateTimepicker

• Size: Does not matter in this type

• Translation: Open the screen and looking to date.

• Column originen: ddate this is the name of the new field in the database.

• Field Type: Date Time

• Default value: select current_timestamp from rdb $ database

Now press Save above the type of control. You will then whether the field can be created. Press Yes and move the control down slightly. Then press again Add new control to a second control to add.

• Type of control: M Memo Field

• Size: to 0 = infinite

• Translation: Look for Remark

• Column origin: SMEMO this is the name of the new field in the database.

• Field Type: Blob

• Default value: blank

• Left top width and height 120, 300, 18, 300, we want the input level increases.

Even with this, you answer Yes. Then press Save at the top and your work is saved.