Im back with more ...|
Basically I look after handheld terminals and provide support etc. I created a really complex spreadsheet about 2 years ago with multiple sheets, macros and forms to manage the stock, arrange repairs etc.
It works really well but the problem is getting the data back out for reporting or just quick analysis. I have to create scripts for trawling thru the sheets which frankly is a pain in the ass. Database queries are a dream in comparison.
So in the DB i am creating (and learning access at the same time), i have to log them in for testing on tblReturns, which is linked to tblUpdates in a subform so that I can continually add updates. This is all working perfectly.
What I now want to do is update the status and allocation of the logged serial# in tblHHTs and also create a record in tblAllocationHistory all from the same form.
Is it possible?
Is there a limit to how man tables you can update on one form?
Edited by crashVoodoo at 22:06:58 12-01-2012
a Nexus a day keeps the apple away