Input forms - entering a value depends on a vlue in other field

[Viktor]

Hi people, I'm relatively new to access and relational databases and I need a
little help.
I have several tables, and the ones I need help with are the following:

People
========
ID (autonumber)
Name (text)
Last name (text)
Ocupation (text) - this is linked to other table (ocupation (id, ocupation
(text 32))
company (text)
etc...

Companies_type1
-----------------
ID (autonumber)
co_name (text)
etc

Companies_type2
-----------------
ID (autonumber)
co_name (text)
etc...

I'd like to have a single form to input people. (name, last name, ocupation,
company etc)

I'd like the company combobox to be dependent on the value in the ocupation
field (i do this with a combo box, too). In other words, if I select
ocupation A for a new person, then I'd like to see only the companies of
type1 in the combo box for companies, and if I select ocupation B, then I'd
like to see only companies of type2 in the combobox.

Is this possible at all?

Thanks in advance for your time,
Viktor

 

[jahoobob via AccessMonster.com]

First things first. Don't use Name as a field name as it is a reserved word.
You need only one Company table. You can add a field to it to distinguish
between type A and type B.
Go here for what you can do to have one combo's values being dependent on
another combo's selection:
http://www.accessmonster.com/Uwe/Fo...boxes-to-affect-the-list-in-another-combo-box

 

[Viktor via AccessMonster.com]

Thanks for the help Jahoobob,

The thread you suggested was exactly what I needed. Although, after thinking
it over, I think I might decide to use one table for the companies even
though there are some different fields that would have to be empty in the
company table.

First things first. Don't use Name as a field name as it is a reserved word.
You need only one Company table. You can add a field to it to distinguish
between type A and type B.
Go here for what you can do to have one combo's values being dependent on
another combo's selection:
http://www.accessmonster.com/Uwe/Fo...boxes-to-affect-the-list-in-another-combo-box

Hi people, I'm relatively new to access and relational databases and I need a
little help.

[quoted text clipped - 35 lines]

Thanks in advance for your time,
Viktor