lookup fields not populating in grid edit

I have a embedded report editable within a form. I want to select an account which relates to a client related to the current form. The related client lookup field would not populate live before saving so there is no way I can select the account since the related client is not populating in grid edit.

Any solution?

Thanks