«

Quick question for anybody who can help:

I have two tables:

tblUsers
--------
UserID
Name

tblPhones
---------
PhoneID
UserID
PhoneNumber

If I'm collecting the name and the phone numbers (can be multiple
numbers) in one form, what's the best way of placing it in the
database? The question revolves around the UserID and making sure the
tblPhones.UserID = tblUsers.UserID

Thanks for any help!

Oh yes... tblUsers.UserID is automatically incremented in the
database...

MRW wrote:
> Quick question for anybody who can help:
>
> I have two tables:
>
> tblUsers
> --------
> UserID
> Name
>
> tblPhones
> ---------
> PhoneID
> UserID
> PhoneNumber
>
> If I'm collecting the name and the phone numbers (can be multiple
> numbers) in one form, what's the best way of placing it in the
> database? The question revolves around the UserID and making sure the
> tblPhones.UserID = tblUsers.UserID
>
> Thanks for any help!

"MRW" <> wrote in message
news: ups.com...

> Quick question for anybody who can help:
>
> I have two tables:
>
> tblUsers
> --------
> UserID
> Name
>
> tblPhones
> ---------
> PhoneID
> UserID
> PhoneNumber
>
> If I'm collecting the name and the phone numbers (can be multiple
> numbers) in one form, what's the best way of placing it in the
> database? The question revolves around the UserID and making sure the
> tblPhones.UserID = tblUsers.UserID
>
> Thanks for any help!

Is the UserID already known, or are you adding one record to tblUsers and
one or more to tblPhones? If the former, is tblUsers.UserID an identity
field? If so, you can retrieve the identity by SELECT @@IDENTIY or SELECT
SCOPE_IDENTITY. Then you can use that to pump the records into tblPhones.

Based on that fact that you mention that the UserID is an auto
incremented field, I am assuming this is an IDENTITY and the SELECT
@@IDENTITY in your SQL should do it for you.

MRW wrote:
> Quick question for anybody who can help:
>
> I have two tables:
>
> tblUsers
> --------
> UserID
> Name
>
> tblPhones
> ---------
> PhoneID
> UserID
> PhoneNumber
>
> If I'm collecting the name and the phone numbers (can be multiple
> numbers) in one form, what's the best way of placing it in the
> database? The question revolves around the UserID and making sure the
> tblPhones.UserID = tblUsers.UserID
>
> Thanks for any help!

Thanks for the feedback!

I'll be honest. I'm not familiar with the @@IDENTITY. Can you give a
quick example on how it is used (VB)?

Thank you for the help!

Sarat Pediredla wrote:
> Based on that fact that you mention that the UserID is an auto
> incremented field, I am assuming this is an IDENTITY and the SELECT
> @@IDENTITY in your SQL should do it for you.
>
> MRW wrote:
> > Quick question for anybody who can help:
> >
> > I have two tables:
> >
> > tblUsers
> > --------
> > UserID
> > Name
> >
> > tblPhones
> > ---------
> > PhoneID
> > UserID
> > PhoneNumber
> >
> > If I'm collecting the name and the phone numbers (can be multiple
> > numbers) in one form, what's the best way of placing it in the
> > database? The question revolves around the UserID and making sure the
> > tblPhones.UserID = tblUsers.UserID
> >
> > Thanks for any help!

I feel generous today, so here you go. 2 mins on Google could have got
you that.

http://support.microsoft.com/default...en-us%3B815629

MRW wrote:
> Thanks for the feedback!
>
> I'll be honest. I'm not familiar with the @@IDENTITY. Can you give a
> quick example on how it is used (VB)?
>
> Thank you for the help!
>
> Sarat Pediredla wrote:
> > Based on that fact that you mention that the UserID is an auto
> > incremented field, I am assuming this is an IDENTITY and the SELECT
> > @@IDENTITY in your SQL should do it for you.
> >
> > MRW wrote:
> > > Quick question for anybody who can help:
> > >
> > > I have two tables:
> > >
> > > tblUsers
> > > --------
> > > UserID
> > > Name
> > >
> > > tblPhones
> > > ---------
> > > PhoneID
> > > UserID
> > > PhoneNumber
> > >
> > > If I'm collecting the name and the phone numbers (can be multiple
> > > numbers) in one form, what's the best way of placing it in the
> > > database? The question revolves around the UserID and making sure the
> > > tblPhones.UserID = tblUsers.UserID
> > >
> > > Thanks for any help!

Ok, looks like I pasted a dummy link there. Here is another go.

http://www.informit.com/articles/art...&seqNum=4&rl=1

MRW wrote:
> Thanks for the feedback!
>
> I'll be honest. I'm not familiar with the @@IDENTITY. Can you give a
> quick example on how it is used (VB)?
>
> Thank you for the help!
>
> Sarat Pediredla wrote:
> > Based on that fact that you mention that the UserID is an auto
> > incremented field, I am assuming this is an IDENTITY and the SELECT
> > @@IDENTITY in your SQL should do it for you.
> >
> > MRW wrote:
> > > Quick question for anybody who can help:
> > >
> > > I have two tables:
> > >
> > > tblUsers
> > > --------
> > > UserID
> > > Name
> > >
> > > tblPhones
> > > ---------
> > > PhoneID
> > > UserID
> > > PhoneNumber
> > >
> > > If I'm collecting the name and the phone numbers (can be multiple
> > > numbers) in one form, what's the best way of placing it in the
> > > database? The question revolves around the UserID and making sure the
> > > tblPhones.UserID = tblUsers.UserID
> > >
> > > Thanks for any help!

Great! Thanks a lot!


Sarat Pediredla wrote:
> Ok, looks like I pasted a dummy link there. Here is another go.
>
> http://www.informit.com/articles/art...&seqNum=4&rl=1
>
> MRW wrote:
> > Thanks for the feedback!
> >
> > I'll be honest. I'm not familiar with the @@IDENTITY. Can you give a
> > quick example on how it is used (VB)?
> >
> > Thank you for the help!
> >
> > Sarat Pediredla wrote:
> > > Based on that fact that you mention that the UserID is an auto
> > > incremented field, I am assuming this is an IDENTITY and the SELECT
> > > @@IDENTITY in your SQL should do it for you.
> > >
> > > MRW wrote:
> > > > Quick question for anybody who can help:
> > > >
> > > > I have two tables:
> > > >
> > > > tblUsers
> > > > --------
> > > > UserID
> > > > Name
> > > >
> > > > tblPhones
> > > > ---------
> > > > PhoneID
> > > > UserID
> > > > PhoneNumber
> > > >
> > > > If I'm collecting the name and the phone numbers (can be multiple
> > > > numbers) in one form, what's the best way of placing it in the
> > > > database? The question revolves around the UserID and making sure the
> > > > tblPhones.UserID = tblUsers.UserID
> > > >
> > > > Thanks for any help!

"MRW" <> wrote in message
news: oups.com...

> Great! Thanks a lot!

Sarat's comment about Google is very relevant, though... you really could
have found this out for yourself in a matter of seconds...

I've been on Google searching for things for hours. I did not find
anything that would have led me to @@IDENTITY. So when he told me, I
simply asked if he had a quick example on how to use it while I've got
him.


Mark Rae wrote:
> "MRW" <> wrote in message
> news: oups.com...
>
> > Great! Thanks a lot!
>
> Sarat's comment about Google is very relevant, though... you really could
> have found this out for yourself in a matter of seconds...