hey there everyone, i need some code to pull data from two tables in Access97.

My situation is this. i have to gather some info about a certain machine and i have info in 2 different tables. i need to be able to pull the data from the 2 tables, update it if need be and then add the new info back to the two tables. i have tried a copule different appraoches to this but have been reletivly unsucessful. thanx for any help.