Record detail page

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):

  1. Basic information, name & supplier.  This stays there as long as you are on this page.
  2. A row of links that open different groups of the data: Activity log, variants, etc. Click on the links to flip between groups.
  3. The third section depends on the group selected. Initially this has the Activity log. The activity log  shows dates of changes to the record, and any new sales, orders, etc which have been added recently. A complete log of all updates is stored in an audit trail table.
  4.  At the bottom of the page are buttons to edit or  delete the row, plus buttons to list the user table or return to the home page.  You can't delete the row in this case because there are transactions for this user. You would need to delete these records first. The superuser can however always delete records if necessary.

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.

Next: Edit information (complex)