C
Craig
I am having my first go at building a database and need some help with using
search functions. My database has around 600 records, each of which describe
an inventory item. These items are split into groups such as pedestrian
mowers, mini tractors, chemical equipment etc. There is another field which
lists the unique inventory number for each item.
What i would like to do is to have two drop down menus. The first would list
all the groups. By selecting the group you wanted it would then bring up all
the relevant inventory numbers. Ideally by selecting the correct inventory
number it would bring up the record for that item.
Can someone just explain how to do this.
Thanks in advance.
search functions. My database has around 600 records, each of which describe
an inventory item. These items are split into groups such as pedestrian
mowers, mini tractors, chemical equipment etc. There is another field which
lists the unique inventory number for each item.
What i would like to do is to have two drop down menus. The first would list
all the groups. By selecting the group you wanted it would then bring up all
the relevant inventory numbers. Ideally by selecting the correct inventory
number it would bring up the record for that item.
Can someone just explain how to do this.
Thanks in advance.