Hi all. I have set up a couple of tables in my equipment control database. One table has one record per piece of equipment, the other table has the date and location of where the tool is (was) used. I need to update the field in the equipment table that shows where the equipment IS (lastloc) with the move to field (movto) from the location table. There is a one to many relationship between the location table and the equipment table, that way I can keep the use history of the equipment, so I need to pick out the last entry for that equipment (movdate)
Are you wanting to hire someone to do this for you?
I am sure Kevin will do the job if you want to hire someone.
Otherwise, yes it can be done. ANYTHING can be done in programming if you have enough info.
Explain your tables better and exactly what you want help with and we might be able to help you.
Kevin:
Please provide information on how I would go about hiring you.
You can start by PM’ing me your files/database sql so I can review what you have. You can pay me by Paypal.