By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Pulling last input from one table and updating another Table

P: 2
Hello, first off I have generally been able to find most the info I needed by searching through the board for it. However I couldnt find anything pertianing to this so I decided it was probably time to register and ask.

I have several tables setup one of which is for assets (trailers) inorder to keep up with them. On my form the form data goes into the main table (D) which will be multiple rows. I would like somehow to pull up the last enter records based on trailer number and location of trailer currently. for instance:

trailers
trailernumber, VIN, Dropped, Preloaded, Deliverydriver

D
Dropped, Preloaded, Deliverydriver, trailernumber, blah, blah , blah(multiple other fields)

When I pull up trailer data I would like to see where the 30 trailers are currently with the updated info without having to search through all the records and figuring it out on my own.

Any help would be appreciatted!
Dec 14 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hello, first off I have generally been able to find most the info I needed by searching through the board for it. However I couldnt find anything pertianing to this so I decided it was probably time to register and ask.

I have several tables setup one of which is for assets (trailers) inorder to keep up with them. On my form the form data goes into the main table (D) which will be multiple rows. I would like somehow to pull up the last enter records based on trailer number and location of trailer currently. for instance:

trailers
trailernumber, VIN, Dropped, Preloaded, Deliverydriver

D
Dropped, Preloaded, Deliverydriver, trailernumber, blah, blah , blah(multiple other fields)

When I pull up trailer data I would like to see where the 30 trailers are currently with the updated info without having to search through all the records and figuring it out on my own.

Any help would be appreciatted!
From your desciption I would guess that the table D is a transaction table which will hold historical records of all the data that was in the trailers table etc. The only way to do this is to use some kind of Timestamp or unique ID.

Either way you could get the query to return the record from D where the trailer number matches and with the highest timestamp or unique ID.

Mary
Dec 15 '06 #2

P: 2
So I can query it based on largest id autonumber per trailer number? Can you point me in the right direction to set that up? Not sure how to filter it based on that per trailer number also.
Dec 18 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.