Thanks, Mark. Just getting back to working on this tonight. Yes, I'm already capturing the date/time. Just not sure how to validate that...how to say, okay this is NOW...so what's the closest behind it?????
Dian ~ -----Original Message----- From: Mark E [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 4:19 PM To: [EMAIL PROTECTED] Subject: Re: [ASP] Need a little "logic" Dian, If it were me, I would use capture a timestamp upon inserting the record and using this to get the most recent. Or, use what you suggested with the ID. Either would work. Mark Dian Chapman <[EMAIL PROTECTED]> wrote: Hi folks... I'm acutally working on a Word/DB Automated form...but it's the same logic. And right now that's exactly what I need... I have a CustomerTbl and TransactionTbl. (This is a DB form for a bank.) I want to be able to capture the LAST transaction so I can populate the Word custom dialog box with the details of the last transaction. What would you say is the best way to capture the last transaction info? And help with code would be mighty helpful, too! <cheesy grin> It's a OneToMany relationship between the customer table and the transaction table. I have the date of the transaction...but think it might be easier to just capture the last record for that person? Since I'll need to run a query to join up the tables to find all the transactions for that customer, anyway...I'm GUESSING that I could find out the highest record number in that query??? That would be the record for the last transaction and then I could use that to create the RS for the dlg population? My other thought is to...at the time the transaction goes into the transaction table...I'll have the customer's record available anyway...so maybe I should just capture the new transaction record number and pass that into a field in the customer table? Then...when I need that default info from the last, I could just grab the number from that LastTransactionNo field and run a query for that record? I don't know? But then...that's why I'm asking the experts here cos' I'm somewhat at a loss for what might be the most sensible route to go. Note...that this is just a Word form passing data between a simple Access DB...no SQL or transaction server involved here! TIA... Dian ~ (And yes Ray...I know I owe you a reply about another matter...I'm working on it!) --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 6/23/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 6/23/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
