The example we are looking at now is a fictitious product file. Click here to see this in action for our test user file. The content for this table is defined by the product table schema.
The page is in four sections (above):
Click on Variants. This lists product variants. :
In this case we have set up different models or types of product, and for each model there are different colours.
Now click on Transactions.
These are lists of product sales or purchases. Click the list buttons to flip between the two lists. Only the most recent transactions are listed, but if there are more transactions there will be a link to a complete list.
In the test data the purchased orders are normalized (each order line is a separate record with a link back to the product). The sales orders are denormalized with the order lkines included in the order record. .Both types are listed.
Now click on 'orher'.
These fields are included because of the product groups selected. Edit the product group and click on 'Battery powered' save the record and then re-edit. The 'other' group now includes a couple of extra fields. Unclick the product group and the fields are removed. This is an example of the user of the subschema feature. The subschema's are accessed from the admin page.
Note that if you unclick a product group the fields are removed from the screen but the data is not deleted. It remains in the record.