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 <*> 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/
