If you separate the revision value into its own field, you can use sorting to isolate the record for a given part with the most recent revision number. Found sets can be sorted, portals can be sorted and relationships can all be sorted.
Thanks Phil, I separate the revision field and sorted in descending order and go to the first record, how should I isolate the found set and display the latest revision only on all records?
Sort your records first by Part, then by Revision number in descendining order.
Replace the body layout part with a Sub Summary layout part "when sorted by Part number". Put your fields in this sub summary layout part as though it were the body.
Note: This layout will be blank whenever the records are not sorted by the Sub Summary layout part's "sorted by" field.