![]() Starting with FileMaker Pro 13 we have the ability to hide objects, so this button could easily be hidden instead of disabled. Since we don’t need to track serial numbers for this item, the portal is empty. Let’s look at the detail view for the iPhone case. In our example, we only have 10 iPhones, but if you have 1,000 iPhones, then manually entering that data will take time. Ideally, you would want to have some kind of automated process to enter serial numbers rather than manually enter them. There is also a button to add more serial numbers. Notice that the item record for the iPhone has related Serial Numbers. The first mockup shows a list of items:Ĭlicking the left caret navigates the user to the detail view: Let’s take a look at some mockups of simplified user interface layouts to see how the Item and Serial Numbers might be displayed on screen to a user. There isn’t a way to diagram the data model to indicate which items require a serial number. (Technically, it means that an item must have at least 0 serial numbers). This indicates that a serial number is not required for all items. Notice the circle to the left of the “crows foot” in the ERD. One way to model this data need is to have a serial table: You’ll want the phones to have a serial number but you don’t need to have a serial number for the cases. You also purchase phone cases for those phones. You carry both iPhones and Android phones. You buy phones in bulk and distribute them to your team. To illustrate, let’s suppose you have an Asset Management Inventory system and some of the items you track are phones. The purpose of a serial number is to track a unique instance of a product. Some products - either purchased or manufactured - may require a serial number. Make your life easy! Start your next inventory project with Trayse Inventory, an open source inventory management solution built on the FileMaker platform. Open source inventory solution now available!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |