How to save a record with 2 base tables

[Kabethy]

Hi everybody,



I am new in Access, very likely this is very simple.

I am trying to update a record in a form that has a stored procedure as a Record Source. The stored procedure has a left join, as half of the fields in the form are from one base table and half from the other. I know we cannot save with 2 base tables so I add a button "save" to do so with another query but when I want to update the fields in the form I am not abel to write or fill in the fields so I dont even get to try my save query.

The form only allows to update or fill in information for the fields corresponding to the first table =(.

Please do you have any idea how this can work?

Thanks

[burrina]

Are you using a Union Query? If not, then your relationships are off!