Query does not allow to add a record

rdev

Registered User.
Local time
Today, 17:43
Joined
Mar 2, 2009
Messages
18
I have the folloawing tables:-
tblshipmaster with fields( IMO_Num,Ship_Name)
tblvoy with fields (Voy_num,IMO_Num)
tblquotation with fields(Quotation_Num,Voy_Num)
tblapprovequote with fields (App_Num,Quotation_Num)
I have relationships set between the tables
When I put a query , which I'll eventually use for a form , the query does not allow me to add record to it , The query will select as follows:-

App_Num,Quotation_Num from tblapprovequote
Quotation_Num,Voy_Num from tblquotation
Ship_Name from tblshipmaster

What could be the reason? I have attached the file
 

Attachments

A quick glance at the db shows that you are using lookups in the actual tables. Never a good idea. I don't use lookups on the actual table level...but I gather that is the cause of the query not being updatable.
 

Users who are viewing this thread

Back
Top Bottom