Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3
I have 3 forms
Patriot_Time_Entry
Client_Rate_Table
Work_Type
I am working in the Patriot Time Entry form
When I select a Work TypeLookup that matches a Company Name in the Client Rate Table, I want to populate fields in the Patriot Time Entry Form.