Populating table field

[Svelte Poshy]

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!

[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/