AnsweredAssumed Answered

Handling Identical Part Numbers With Different Revisions

Question asked by newboard on May 19, 2017
Latest reply on May 19, 2017 by beverly

I 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!