Cathy

,

when

you say that the code

[However, if I try to find the lowest order id that does not have it's emailsent...

kung lao, one post is adequate for your purposes, we will see it. please stop double posting.

how do i load an image i have tried using insert image, but its not doing anything. i wanted to upload the screen shot

yes its possible, you need to specify on your output screen

please do not double post, we are working on your problem

mm.. i think this has happened to me before which is maybe why i use notepad or QA to write my reply first, for long posts of course

 A huge chunk of the work is going into building an Access data transfer tool (DTS is not an option for a bunch of reasons outside my control) and...

that was my experience as well

can you post your tables ddl?

if you have a column in your Order Header table that contains a count of order detail lines, you could use a trigger on...

my suggestion would be

• to halt any development on your access dbs,
• get the sql db to work with your apps
• then do the access db upgrade again, and
• just...

did u get it to work from what i have you? i don't think  you are required to create the login, in my case i ended up do it because...

i have never gone wrong with the identity column. even in cases where i need to generate my own unique ids like claim no, or ref no for the client...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=198387

can you issue products from more than one receipt batch, if so what is the business rule

are you implementing FIFO for a stock management system? if possible give us more details, it might be a case of a poor design of your database