W
wwojtale
I'm trying to create an inventory database that has two main types of items,
each with distinctly different sub-items. I want to select the general item
in one table field and and have my selection generate the appropriate list of
sub-items in the next table field.
I have set up 2 different tables with the required lists of sub-items.
I have tried to set up a query, but since I'm comparing two tables that
separately relate to the inventory table, the error message suggested that I
separately create the query and then enter into SLQ - unsuccessful.
I was able to get 1/2 of the "where" equation to function, but not reliably.
In otherwords - if I changed my inital input, the list didin't change with
it.
I have worked on this in various context over several years - this is the
closest I've come. Please help - don't want to do it with multible fields.
each with distinctly different sub-items. I want to select the general item
in one table field and and have my selection generate the appropriate list of
sub-items in the next table field.
I have set up 2 different tables with the required lists of sub-items.
I have tried to set up a query, but since I'm comparing two tables that
separately relate to the inventory table, the error message suggested that I
separately create the query and then enter into SLQ - unsuccessful.
I was able to get 1/2 of the "where" equation to function, but not reliably.
In otherwords - if I changed my inital input, the list didin't change with
it.
I have worked on this in various context over several years - this is the
closest I've come. Please help - don't want to do it with multible fields.