Keyed application references

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