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...
I am sure this isn't terribly complicated, but I can't even think where to start at the minute! Basically I have a database which consists of two tables. One with data about employees and another which may have several related rows about an employees absence. Below are the fields in each...