Search the Community
Showing results for tags 'numbers'.
Found 2 results
NewBoard posted a topic in RelationshipsI am attempting to create an inspection sheet for our Quality Lab. Right now, all parts will be on revision 1. However, once this is up and running, these parts will receive revisions. What will ensue is a table with multiple identical part numbers, but different rev levels. What I want to happen, is that whenever an employee makes a new inspection sheet, FileMaker will only request the data from the newest rev. My proposed solution is to have another field that will be 0 if it's not the newest, and 1 if it is the newest. Then the inspection sheet will only request data from records that have a 1. I have not yet figured out how to do this though. If someone else has a better solution though, I am all ears!
I have a number field that I would like to auto enter either (2, 3, or 9) at random every time a new record is created. Please help! Thanks Matt I tried to do a sequenced auto enter but filemaker simply counts up from 1 and I can't specify the 3 numbers. Thanks