Single Parent Style GridLinker Component
This lesson shows how to make a GridLinker component that displays a single record from a parent table and a grid from a child table in the following format. [Picture]
Create a new tabular grid based on the AlphaSports Invoice_Header table.
Display the Grid Fields page of the Grid Component Builder.
Move the "Invoice_Number", "Customer_ID", "Date", "Sales_Rep", "Delivery_By", "Pay_Method", "Sales_Tax", "Discount", "CC_Number", and "CC_Expiration" from the Available Fields list to the Selected Fields list.
Make choices under Display Settings > Display Format for fields that need special formatting (such as Currency fields).
Check the Column Properties > Hide Column property for all but the first field that you will display on the grid.
Erase the Column Properties > Column heading property for the first (and only) field that is not hidden.
Check the Column Properties > Freeform layout property for this field.
Click in Column Properties > Freeform template property field to display the Freeform Column Layout dialog. [Picture]
Select the fields that you want to display from the Available Fields list.
Place the fields (illustrated above) into an HTML table. Either add the table code here manually or click HTML Editor and add the appropriate HTML styling (illustrated below). [Picture]
Click Save > Close > OK to return to the Grid Component Builder.
Create a second grid component for the child table. Remember the child table has to include (but does not need to display) the field that links it to the parent table. [Picture]
Create a gridlinker component that associates the two tables with their linking fields. [Picture]
Place the grid linker component into an A5W page and publish it.
Alpha Five Version 6 and Above