Search the Community
Showing results for tags 'revisions'.
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!
Often we have to revise estimates for a customer, and they may come back and order against an estimate that is not the most recent. I am trying to find the best way to tie all the estimates together with the same Estimate or Job #, and increment a revision #. So far I've created a Job# field, and a Revision number field, but having trouble getting the revision number and job number to increment correctly when I have a new estimate vs a revision. Any suggestions?