Cannot edit form data when record source references multiple tables

Hi Experts,
I recently modified a form such that its record source used to reference only one table, now it references multiple tables. As soon as I did, I could no longer add or modify data in the form. I notice another question on Experts Exchange dealing with the same issue that sits unresolved.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23099879.html
I find it hard to believe that Access has such a restriction, or that there is no way to resolve this issue.

Here is what I have in the database:
My database includes a movement_header table and a vessel_info table. Movement_header.vessel_id is FK to PK vessel_info.vessel_id. Other fields in the vessel_info table include vessel_name. Good database design dictates that the vessel_name does not belong in the movement_header table.

Here is what I HAD in the application:
The record source for my movement_header continuous FORM previously consisted of only one table, the movement_header table. At that time I was able to add and modify data in the form, but I could not soft the records by vessel_name, I could only sort by vessel_id. (Note: the row source for a combo box in the form is this:
SELECT [VESSEL_INFO].[vessel_index], [VESSEL_INFO].[VESSEL_NAME], [VESSEL_INFO].[VESSEL_TYPE] FROM [VESSEL_INFO] ORDER BY [VESSEL_NAME], [VESSEL_TYPE];

Here is what I NOW HAVE in the application:
Because I need to sort by vessel_name, the record source for my movement_header continuous FORM now includes multiple tables:
SELECT movement_header.*, vessel_info.vessel_name from MOVEMENT_HEADER, vessel_info where movement_header.vessel_id = vessel_info.vessel_index;
As soon as I implemented this, I was able to sort records in the form based on vessel_name, but I was surprised that I could no longer add or modify records in the form...basically rendering it useless.

My question is:
Is there a way that I can sort data in my continuous form by vessel_name and still have the ability to add and modify records? Or is Access truly incapable of doing this?

This looks like a difficult issue. Any input would be most appreciated.

Thanks,
GuyStart Free Trial