Field showing current staff assigned to report
We write techical reports. The reports can go through up to 6 to 7 revisions and the revisions are not alwasy completed by the same person. In filemaker, each report is a record. In each record, I list each revision date and staff who completed the revision.
I need to create a field that could show me the most recent staff person who has completed the report. Staff member names are in fields labeled: Orignal Staff, 1st revision staff, 2nd revsion staff, 3rd revision staff, 4th revision staff, 5th revisions staff, 6th revision staff (the fields are text fields).
Instead of a set of fields for each revision, create a table of related records for listing the revising staff. Not only does this make displaying the most recent revisor easy to do, it allows for complete flexibility for the number of revisors listed for a given document.