I need to create a field with a lookup value that gives values depending on what the previous field displays. e.g. If one filed displays 'PC' then I need the next field to show dropdown list of the possible PCs. Or if one field says 'Monitor' I need the next filed to give a drop down list of only the available Monitors... not all monitors, PCs, printers....... etc.
Anyone know how to do this? I have a separate table which includes all the different types of pcs and monitor etc that we need the other table to read from.