![]() Click on ‘Add Product’ button and up pops the pick list. You can test the Pick List from the Invoices layout of the Demo File. This approach can help keep it clear to the user what is going on, and where they are in the database system. ![]() With Card Windows, you get a linear workflow – add an item, then pick or cancel and end up back where you started. Adding a Cancel button allows the user to back out of selecting any products with no changes made to the invoice. Using a Card Window has the benefit of giving the user a good sense of where they are in the database, because they can see the previous layout in the background greyed out. You could do this same technique without using a Card Window, using a regular window and centring it in the screen. This technique employs Card Windows, which were added in FileMaker 16, so you will need at least that version to use this demo file. Contacts have Invoices, Invoices have Line Items and the Products table has no linkages. Below is the relationship graph of the Demo File. The example I am using is a simple invoicing solution, where you have lots of products to pick from and you want to make that accessible on an invoice. The beauty of pick lists is that they don’t require any complicated relationships to display the data. ![]() Whenever you want to get data from somewhere in a database and and there is a long list of items to choose from, this is a good approach. This is a pretty simple technique and can be adapted to many different aspects of a solution. Recently, I was explaining the Pick List technique for a friend and thought there might be a good example online, but couldn’t find one, so here is my version.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |