None Uptables?

[Daniel]

Here my problem,

I have three tables whos' information I need to combine together so that it gets displayed in 1 form (so far easy enogh .. or so I thought), with a fourth table that relates the information of the other three together. My first Table is my main table ("Drawing Status Tbl"), the two others contains dates (many dates for one drawing) but I only want to display the lastest date. so I created the following 2 queries:
*********1
SELECT [Drawing History Tbl].Id, Max([AIF Need Date Tbl].[AIF Need Date]) AS [MaxOfAIF Need Date], Max([CDI Commit Date Tbl].[CDI Commit Date]) AS [MaxOfCDI Commit Date]
FROM ([Drawing History Tbl] LEFT JOIN [AIF Need Date Tbl] ON [Drawing History Tbl].Id = [AIF Need Date Tbl].[Drawing Issue Id]) LEFT JOIN [CDI Commit Date Tbl] ON [Drawing History Tbl].Id = [CDI Commit Date Tbl].[Drawing Issue Id]
GROUP BY [Drawing History Tbl].Id;
*********2
SELECT [Drawing Status Tbl].*, [Max Dwg Dates Qry].[MaxOfAIF Need Date], [Max Dwg Dates Qry].[MaxOfCDI Commit Date]
FROM [Drawing Status Tbl] INNER JOIN [Max Dwg Dates Qry] ON [Drawing Status Tbl].[Drawing ID] = [Max Dwg Dates Qry].Id;
******

my problem is now I can no longer edit/enter the information that appears in my form. How can I change my query to on display the max date but still be able to edit information?

thank you for your help,

Daniel