Using the Application Reference field allows the linking of tables together, however I feel this could be improved substantially:
- Allow "key" Blocks (Primary keys) - eg, Customer Account
- Only allow a single entry in the field - perhaps check box on the Block within the App
- Restrict length of fields - eg, Customer Account only 10 characters
- Allow display of extra fields in other Apps - eg, if an Order App has a reference to the Customer app via a Customer Account field, the Order App displays the linked key field (Customer Account) and the extra info like Customer Name and Customer Phone No - these selectable on the referencing App (Order App in this example) when creating the link
These simple improvements will make a great improvement to creating more intelligent Apps
Please sign in to leave a comment.