Using form to add record to table where records are limited by lis

[Tony]

Hi all...
Bit hard to explain what I am doing here but I'll have a go

In Excel if I want to limit the number of records shown in rows I apply a
filter for example to col1 which reduces all remaining cols. Then filter on
col2 to reduce further etc etc until I have only a few records left to look
at.

I want to do this in access on a form BUT...

I want to create a table of records that has an ID, Date stamp, a part
number, qty
I want this table to get its information from a form.
I want the form to use a master table which includes the "part number" from
above but where that part number is derived by filtering the records in the
master table by the preceding columns.
So the records get written to a records table but how you come to arrive at
what the "part number" is, is to "filter" the master table until there are
few options left. Selecting one will put that related "part number" into the
records table.

Hard to explain.
I can email the table to anyone who wants it and discuss the concept.
I know it can be done but cant get my head around how to do it.

TIA