I'm working to get a web app for equipment inventory, which would be access by users to record and update inventory and service repairs. Please bare with me since I'm very new to this stuff.
So far i have a database which we can call "edpdb"
and it has two tables "inputview" and "service"
"inputview" holds all inventory data. "service" will hold all
service done to equipment in the "inputview" table. I have
no problem getting the forms for inputting and viewing data
in the "inputview" and the same goes for the "service" table.
but what I need is to use the "service" table to update records
in the "inputview" table. for example in the "inputview" i have a
field named "serial" and in the "service" table I have two fields named "serialreplace" and "serialcurrent" when I enter a service form I would like the form to grab the current info form the "inputview" record and display it in the service form and when i enter the "serialreplace" it will replace the value in the "serial" field of the "inputview" table. I hope this seems clear let me know if it isn't if you need a copy of my db or web app that i have so far let me know.
many thinks to anyone that helps!!!!
