I have a field name "Responsibility" that I want to use as a status field only. It is just to tell us who is responsible for that record.
I am using two tables "Tbl_WO_Log" and "Tbl_Building_Asset_List". The building asset list table is not updatable, but it is where the responsibility field is located.
I created a query with "Asset ID" as the connecting fields.
Since the "Tbl_Building_Asset_List" is not updateable it is not allowing me to add new records.
How can I add new records but have this one un-updateable field on the form.
- Or -
Is there a way to have a message popup with the responsible party for that record.