I am having an issue retrieving only the last record for a specific form entry. I have a form named Morning Report. Users select their project from a lookup in the form to populate a new entry specific to a particular project for updates. When they select the specific project, I need the form to auto populate the last entries of some of the form from that specific project.

Right now, if another user enters in another project, the form pulls the last entries from the last entry no matter the project. I need the fetch to work based on a specific "Job Number" match. So if you choose a different project in the lookup, the fetch will retrieve only the last entries for that particular project.

Can anyone help?