J
joecosmides
I have a query that is using 2 tables in it. One table in that query
has a field called LeadDetailID and it is an autonumber and a primary
key. The 2nd table in that query has an autonumber field called SOID
and it is also a primary key.
When a Lead turns into a service order is when the SOID needs to be
used so when I create the service order and use the form called
ServiceOrderF (which uses that query above) I need it to give me the
LeadDetailID (which it does) and also give me the SOID. This always
has worked just fine when using Microsoft Access as the front end and
back end but when I sue SQLExpress as the back end I noticed that the
SOID stays blank until I close the form and then reopen it. Once it is
reopened then I can see the SOID.
As a side note, I notice now that I'm using SQLExpress that when I run
a query such as the SOIDQuery that I created to troubleshoot, When I
start adding data to a new record, the SOID (autonumber field) does
not produce an autonumber until I click the previous record or any
other record for that matter. It's like it won't give me the
autonumber the second I start typing in data like Ms access has always
done. I went back to MS access and ran the same query and the second
you type data into MS access, the autonumber populates right away. How
can I get SQL to do the same? Is there a lose focus command after
update or something like that?
Thanks
has a field called LeadDetailID and it is an autonumber and a primary
key. The 2nd table in that query has an autonumber field called SOID
and it is also a primary key.
When a Lead turns into a service order is when the SOID needs to be
used so when I create the service order and use the form called
ServiceOrderF (which uses that query above) I need it to give me the
LeadDetailID (which it does) and also give me the SOID. This always
has worked just fine when using Microsoft Access as the front end and
back end but when I sue SQLExpress as the back end I noticed that the
SOID stays blank until I close the form and then reopen it. Once it is
reopened then I can see the SOID.
As a side note, I notice now that I'm using SQLExpress that when I run
a query such as the SOIDQuery that I created to troubleshoot, When I
start adding data to a new record, the SOID (autonumber field) does
not produce an autonumber until I click the previous record or any
other record for that matter. It's like it won't give me the
autonumber the second I start typing in data like Ms access has always
done. I went back to MS access and ran the same query and the second
you type data into MS access, the autonumber populates right away. How
can I get SQL to do the same? Is there a lose focus command after
update or something like that?
Thanks