I have a one to many relationship between my 'Clients' table and the 'Jobs' table. I want to show the 'Work Phone' of the most recent job (max starting date) from the 'Jobs' table on my 'Client' form without having multiple records for each client. It seems like it should be simple, but I'm having trouble getting it to work. Does anyone have a solution?

Michael