I have a table “call Log”. In this table I have 3 fields which I need to link together, So that when I choose a value from one field, the next field automatically shows a list relevant to the first field. The 3 fields are “Busines Unit” “Department”and “Location”. Business unit is a lookup wizard, containing 5 entries. Each of these entries would have at least 5 related entries to display in the Department Field. and likewise for Department to Location fields. How can I set this up so that I get only the relevant information in the Department and Location Fields??
