Update a Field

[ypma]

Updating a field within a called record

Good evening fellow Access users.

I am trying to update a field in one table based on the same named field in another table For example the sales form as a tick box which is ticked when an item is sold, I then require to update my stock list to reflect, that this item has been sold, by updating the stock item as sold. This is required for the stock count. Any constructive advice would be appreciated

Regards Ypma

 

[plog]

I don't completely understand what you are trying to do, but when you want to use one form to affect multiple tables, it seems like you haven't set up your tables correctly. Data shouldn't have to be "synched", it should be related. That's why we write queries with joins.

Keeping track of stock is exactly what that method is used for. You keep one table with all debits and credits to inventory, then when you want stock levels you run a query to simply add them all up to see where you are at.

Perhaps you can post a sample database to demonstrate what it is you actually want to accomplish.

 

[ypma]

Plog, I think you are correct, I had not thought it through , so will go back to basic and start again taking on board your comments . Thank you

Ypma