microsoft/access/training/courses - Isolating data query

Ok, I would suggest the following:

TABLE
If you were entering the data in a table, I would simply leave the Second field empty, unless you were entering a FABRIC. Databases can be designed like this, as you will simply record a blank field.

FORM
You could follow the same thinking using the Forms, however, you could program the object on the form (in this case the second field), to only appear, or contain values when you select fabrics. This does require knowledge of SQL (query language), so that the object can know if the First field contains a specific value.

A simple way of saying this is something like:

<b>Show "lookup list" only IF "Field1" = FABRICS</b>
The SQL code would look very different, as it would contain the names of your fields and lookups.

Richard