By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Populating table field

P: n/a
Populating a field in a table depending on another
In my table customers i want to populate the field segmenid depending on
the
choice in the lookup field Typeid. Both fields, typeid and segmentid are
placed in the

table Customers. The field Typeid is a lookup field, looking in the
table Type.
If i choose Typeid 1,2,3,4, or 5, then i want to populate the field
Segmentid as follows:

segmentid = 1. In all the other cases the filed should be populated as
SegmentID = 2
How can i do it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
jmr
If this is on a form, you could add the SegmentID to the pulldown list and
on update of the TypeID, you could specify that SegmentID =
TypeID.Column(3) or whatever column number it is. You can count the
columns in the query and subtract one from that count. The Column()
numbers start at 0.

On 24 Oct 2003 03:11:21 GMT, Svelte Poshy <sv******@yahoo.com> wrote:
Populating a field in a table depending on another
In my table customers i want to populate the field segmenid depending on
the
choice in the lookup field Typeid. Both fields, typeid and segmentid are
placed in the

table Customers. The field Typeid is a lookup field, looking in the
table Type.
If i choose Typeid 1,2,3,4, or 5, then i want to populate the field
Segmentid as follows:

segmentid = 1. In all the other cases the filed should be populated as
SegmentID = 2
How can i do it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.