Print

Subform Tab


(version 2.6)

Browse in Subform

The name of the Browse Form that will be inserted into the subform.
(If this remains blank, the subform will be built as an editable subform.)

Default Filter for Browse Screen

Can contain hard coded strings and / or hash variables.

- #recordID# or #id# can be used to refer to the Primary Key of the Edit Form the Subform is on.






(version 2.5)


The Subform Object is a useful tool to utilise when a record has multiple sub records associated to it, such as a customer with a number of invoices.
A Subform Object can have just about any other type of Object placed in it except a Listbox Object.


LeftCo-Ordinate

This sets the vertical position of the Subform on the page (in pixels from the Left).

Top Co-Ordinate?

This sets the horizontal position of the Subform on the page (in pixels from the Top).


Height

This sets the height of the Subform.

Width

This sets the width of the Subform. If set to blank or 0, the subform will grow as objects are applied, however no scrollbar will appear. If the width is given a number it will grow to that size as objects are added, a scrollbar will appear when it gets too large.

Browse in Subform

Browse Screen to be used instead of editable rows.

Default Filter for Browse Screen

A string (including possible hash variables) used as a default filter for Browse Screen.
This string will transfer to any Form opened by this Browse Screenso that it can be used to set default values in a new record.

eg.



Here is a video of it being used..video (external link)



Table

The name of the table assigned to the Subform.

Primary Key

The primary key is the id field of the table assigned to the Subform.
e.g. invoice_id

Foreign Key

The foreign key refers to the id field that links it to the id of the main form.
e.g. inv_customer_id
In this example there is a Subform of invoices being displayed on the Customers Form. The table that belongs to that Form is called customer and its id field is the foreign key.

SQL

This is where you type the SQL statement to select the data from the table to display in the Subform.
e.g. SELECT * FROM invoice WHERE inv_customer_id = ‘#id#’
This SQL statement will select all the records from the invoice table belonging to a particular customer.

Title Height

This sets the height of the title bar on the Subform.

Blank Rows

This sets the amount of empty rows that are always available.

Deleteable

Option Yes/No. This sets whether rows in the Subform can be deleted. If Yes, a checkbox will appear at the end of every row in the Subform. If the checkbox is subsequently checked, that row will disappear the next time the save button is clicked.

Read Only

Option Yes/No. This option determines whether the Subform will only be visible, and thus not editable.

Subform Odd Background Colour

This sets the odd background colour in the Subform. If this is left blank, the background will be set by the background colour in the Object Style.

Subform Even Background Colour

This sets the even background colour in the Subform. If this is left blank, the background will be set by the background colour in the Object Style.

Subform Selected Row Colour

This sets the background colour for the selected row in the Subform. If this is left blank the background will be set by the background colour in the Object Style and no change will be apparent when the row is selected.
NOTE : clicking on the Fields or Objects in a row will not engage this feature.


Created by: system. Last Modification: Friday 28 of September, 2012 10:42:48 CST by steven.