Hi,
I am new to access and I am trying to create my first database. I am trying to create my first query which is to do with stock levels, I have one table that is stock levels and one with stock to be removed. The information for the stock to removed comes from a form that then stores the info in the table.
Both tables are linked with a relationship between the field 'EquiptmentID' I therefore want to use an Update Query to be able to then update the current stock level from the stock that is being removed. Can anyone help my create an update query to be able to do this?
Many Thanks,
THL
I am new to access and I am trying to create my first database. I am trying to create my first query which is to do with stock levels, I have one table that is stock levels and one with stock to be removed. The information for the stock to removed comes from a form that then stores the info in the table.
Both tables are linked with a relationship between the field 'EquiptmentID' I therefore want to use an Update Query to be able to then update the current stock level from the stock that is being removed. Can anyone help my create an update query to be able to do this?
Many Thanks,
THL