Re: Slightly OT: Lighten things up a little

Ahem, We have a very full feature ... set. cheers, Nelson (from Canada) ;) Dave Watts wrote: > > > na, that would mean I'd have to go out and get a life, > > > and I hear those are expensive. > > > > > > I hear you can get one on Priceline. They're importing > > them from Canada, I believ

SQL Max record ID ?

Hello, I have two tables Table #1 has an automatic increment field (someID). When I add a new record to Table #1 I want to take that someID field just created and use it in Table2 (separate templates) when I create a record for Table #2. That is I want the maximum value for someID in the table.