TABLE: Second Field combo based on first field

[Guest]

Take a table comprising of Gender and Title. How do I set up the table such that Title is a combo field that offers options based on the value of Gender. For example, if Gender is Male, the Title Combo should offer Mr, Sir and if Gender is Female, Title should offer Ms, Mrs etc

Thanks for your help

 

[Tim Ferguson]

For example, if Gender is Male, the Title Combo should offer Mr, Sir
and if Gender is Female, Title should offer Ms, Mrs etc.

and Dr, Prof, Rev, etc go where..?


Tim F

 

[John Nurick]

and Dr, Prof, Rev, etc go where..?

and Dame Hilda Bracket?

 

[Adrian Jansen]

You can do this, just have a table with fields Title and DefaultGender. Add
as many Titles as you want, and assign a Gender to each, with nulls for the
titles with unknown gender, eg Prof. Then feed your combo box from a query
on the table with the gender as a criteria.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Take a table comprising of Gender and Title. How do I set up the table

such that Title is a combo field that offers options based on the value of
Gender. For example, if Gender is Male, the Title Combo should offer Mr, Sir
and if Gender is Female, Title should offer Ms, Mrs etc.

 

[Guest]

Thanks Adrian, I'll try it out

I can't believe the CHEAP and NASTY response from John Nurick & Tim Ferguson (this one is an MVP too!). Obviously they both understood the problem as originally stated.

 

[Adrian Jansen]

Sometimes people have off days.

Responses on this and the other Access groups are *hundreds* of times better
than some of the other groups on Usenet.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Thanks Adrian, I'll try it out.

I can't believe the CHEAP and NASTY response from John Nurick & Tim

Ferguson (this one is an MVP too!). Obviously they both understood the
problem as originally stated.

 

[Guest]

Thanks for your assurance. I agree, these (Microsoft) newsgroups are better than any other. I consult the Excel.Programming newsgroups most of the time-it is probably the most active newsgroup and the standard is EXCELLENT.

 

[Tim Ferguson]

I can't believe the CHEAP and NASTY response

Not guilty on either charge. You'll get more flak from users by over-
complicating their interface than by leaving them to get on with it. It's a
bad idea, inadequately thought out: and I thought we were fairly kind to
point it out in light and humourous fashion.

Oh well...


Tim F

 

[Adrian Jansen]

I have to disagree. It seems to me fairly sensible that when you are
entering a persons details, one of the first things you are likely to enter
is the title. And if you choose it from a list/combo, then you can limit
the choices to sensible titles, and at the same time pick up the gender in
many cases, which you often need anyway. Conversely, if you select the
gender first, you can limit the titles to show only the ones applicable to
that gender. Either way, you reduce some of the work for the data entry.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[John Nurick]

I have to disagree. It seems to me fairly sensible that when you are
entering a persons details, one of the first things you are likely to enter
is the title. And if you choose it from a list/combo, then you can limit
the choices to sensible titles, and at the same time pick up the gender in
many cases, which you often need anyway. Conversely, if you select the
gender first, you can limit the titles to show only the ones applicable to
that gender. Either way, you reduce some of the work for the data entry.

Limiting the list to "sensible" titles is in practice a way of ensuring
that sooner or later the database will reject a legitimate title that
the programmers didn't think of. At a minimum this causes delay and
confusion; at worst it can offend a client and cost big money. More
flexible validation is needed.

Also, data entry people shouldn't be wasting time using the mouse to
select items from combos: they should be using the keyboard and letting
the combo's AutoExpand do the work. In that case a few items more or
less in the list makes no difference to the data entry task.

(In terms of data validation, however, there's a case for checking title
against gender and raising a flag for a female "Mr" or male "Ms".)

 

[Adrian Jansen]

Points taken.

I was assuming the scenario where the titles list would be taken from a
table, easily added to by the data entry people as well, but subject to some
review as to what sort of titles were being created.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control