Cell dependent on value of other cell

L

Luc Ferrari

The field 'Department' should be linked to the value from the field
'Division'.
Each Division has many Departments.
Both the Division & Department fields are showed as list fields.
So when i select a Division, the list in the Department field should be
limited to the Departments in that division.

How should i do this in a query?

Thanks,

Luc
 
J

Jeff Boyce

Luc

If you are attempting to do this in a query, I don't believe you will be
able to.

If you were using a form, I'd suggest you search on "Cascading Comboboxes"
to accomplish what it sounds like you are seeking to do.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Adding a space between fields 4
Change Form's Recordsource with SQL Statement? 0
SQL query to display values in a Combo box 2
Logical planning and implementing company's structure in PS 2007 6
creating a table for accessing data via Access forms 5
Table design 4
field drop down dependent on another field 2

Top