We would like to filter a list based on a lookup on the form. The lookup is to the project list. Each new RFI item is created from the parent Project form for the relationship. When a new RFI item is created we want to have the RFI list in the new form filtered by the lookup to the Project. This is to loop over the projects RFI items allowing us to increment the internal RFI number.
Hope that made sense.