Yes, at this point they just want/need a simple Access DB versus needing/wanting SQL svr.
Tks... Dian ~ -----Original Message----- From: Shawn K. Hall [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 2:34 PM To: [EMAIL PROTECTED] Subject: RE: [ASP] Need a little "logic" Hi Dian, > What would you say is the best way to capture the last transaction > info? I'd try something like this: SELECT * FROM TransactionTbl WHERE (TransactionTbl.CustomerTblID = ID_GOES_HERE) ORDER BY TransactionTblID DESC > 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? Sure - but triggers would really do wonders here for you. Does it *have* to be an Access db? Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== Humperdink: Surrender! Westley: You mean you wish to surrender to me? Very well then, I accept. -- The Princess Bride ------------------------ 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 --- 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 --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
