Hi
First post here, after getting back into Access having not used it for some 20 odd years - and trying to get to grips with it again.
Anyway, I've created a very simple stock database for my company which works fine (essentially product name/quantity/value) which is updated via a form, but now but trying to find the easiest way to add a transaction history log to it, so I can quickly view and search stock movements (in / out).
Can anyone suggest the best way to do this? Surprised Access still doesn't have this feature as default (as far as I can tell at least)
thanks
G
First post here, after getting back into Access having not used it for some 20 odd years - and trying to get to grips with it again.
Anyway, I've created a very simple stock database for my company which works fine (essentially product name/quantity/value) which is updated via a form, but now but trying to find the easiest way to add a transaction history log to it, so I can quickly view and search stock movements (in / out).
Can anyone suggest the best way to do this? Surprised Access still doesn't have this feature as default (as far as I can tell at least)
thanks
G