Hi,
I'm an occasional Ms-Access developer, so there is still a lot of stuff that I don't get...
Right now, I'm working on a database that stores contractual information.
One of the form that I created is based on a query that links several tables.
When I try to insert a record in this query-based form, I can only update the fields that are used to build relations with other tables.
The fields that are not involved in the database relations are simply locked.
However, when I am navigating records, I can update all fields.
So basically, I only have problems when I want to insert a new record.
---New Info:
Here is the query behind the form
SELECT Contract_info.Ctrct_Cpy_ID,
Contract_info.Ctrct_ID,
Contract_info.Ctrct_Ref,
Contract_info.Ctrct_Branch_ID,
Contract_info.Ctrct_Start_Date,
Contract_info.Ctrct_Service_ID,
Contract_info.Ctrct_End_Date,
Contract_info.Ctrct_Duration,
Contract_info.Ctrct_TO_month,
Contract_info.Ctrct_Investment_Y_N,
Contract_info.Ctrct_Investment_Amount, Contract_info.Ctrct_Terms_of_Payment,
Contract_info.Ctrct_Lunch_p_Day,
Contract_info.Ctrct_Lunch_u_price,
Contract_info.Ctrct_BF_p_Day,
Contract_info.Ctrct_BF_u_price,
Contract_info.Ctrct_Diner_p_Day,
Contract_info.Ctrct_Diner_u_price,
Contract_info.Ctrct_Management_Fee,
Contract_info.Ctrct_Nb_Staff,
Contract_info.Ctrct_Staff_u_price,
Contract_info.Ctrct_Scope,
Contract_info.Ctrct_Comments,
StatusContract.Status_Name,
Company_site.Cpy_Code,
Company_site.Cpy_Name_EN,
People.Name_EN,
Branch.Branch_Name,
Branch.Branch_Name_Code,
City.City_Name,
Service.Service,
Service.Description,
People.Position
FROM StatusContract
INNER JOIN (Service
INNER JOIN (Company_site
INNER JOIN (City
INNER JOIN (ADEN_People
INNER JOIN (ADEN_Branch
INNER JOIN Contract_info
ON Branch.Branch_ID=Contract_info.Ctrct_Branch_ID)
ON People.Staff_ID=Contract_info.Ctrct_Sales_ID)
ON City.CityID=Branch.Branch_City_ID)
ON Company_site.Cpy_ID=Contract_info.Ctrct_Cpy_ID)
ON Service.ServiceID=Contract_info.Ctrct_Service_ID)
ON StatusContract.Status_Ctrct_ID=Contract_info.Ctrct _Status_ID;
==> I have exactly the same behavior when I try to add a line in the table resulting from this query
Thanks a lot for your help...
Regards,
Ferasse.