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
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