Look ups

[Erm]

Is it possible to create a look up list for a field, in which the list displayed will depend upon the contents of the previous cell? EG. I have an 'Area' field (the contents of which is selected from a drop down box). If Communication were selected from this list I need the drop down for the 'Skill' field to display 'Listening and asking questions', 'Explaining, coaching and informal teaching'. If a different option were selected for 'Area' a different list of options would be needed for the 'Skills' field.

PLEASE HELP! This is driving me crazy!

 

[trucktime]

List

It seems to me that you need cascading combo boxes.
Please search the forum, there are plenty of posts and examples
on this topic.

 

[neileg]

I agree with trucktime. However, you must do this in a form, not at table level.