Filemaker 5 serial number

Create a new contact record using your own information or feel free to use the information presented in Figure 1. This can be done through managing the database of the solution. Once selected, your screen should match what you see below in Figure 1. Figure 1. A screen like the one in Figure 1. This is where the options for the field are set. Go to the Auto-Enter tab. Note in Figure 1.

This field is set up to create a serial number only with the creation of a new record. Posted October 17, I'm trying to create a field to enter a serial number, automatically, according to its category.

Link to comment Share on other sites More sharing options AHunter3 Posted October 17, I see no mention of Category in any of your field definitions.

Posted October 18, Thanks AHunter. Why could it be? AHunter3 Posted October 18, Thanks for your reply again! Am I being stupid? I start to wonder It either gives me nothing or "? Oh my god! Am I trying to do something completely over my head? And for each project, I end up with a consecutive "Order ID2" number for easy referencing. Why do I get "? In fact, can we go all the way back to this statement: I'm trying to create a field to enter a serial number, automatically, according to its category.

Posted October 19, In fact, can we go all the way back to this statement You buy phones in bulk and distribute them to your team. You carry both iPhones and Android phones. You also purchase phone cases for those phones. This indicates that a serial number is not required for all items. Technically, it means that an item must have at least 0 serial numbers. The first mockup shows a list of items:. Notice that the item record for the iPhone has related Serial Numbers.

There is also a button to add more serial numbers. Ideally, you would want to have some kind of automated process to enter serial numbers rather than manually enter them. In our example, we only have 10 iPhones, but if you have 1, iPhones, then manually entering that data will take time. More on that below. Moreover, the button is disabled. This script step allows you use any calculated expression to determine the next serial value of a field.

For example:. In the example above, the MAX function is used to calculate the next available invoice number for the related field "Invoice ID". If "Invoices" is the current table, then the formula above may not work as the MAX function extracts the maximum value of the field in the current record.

Instead, use a self-join by creating another Table Occurrence of Invoices and a Cartesian relationship between "Invoices" and "Invoices 2". Then, you can modify the above formula to reference the second Table Occurrence Skip to Main Content. Resetting an auto-enter serial number in FileMaker Pro.