Method to get list by user value

[Sgwapt]

I have 3 tables named Products, ProcesList and ToolList.
The ProcessList uses the Products table to get ProductNo
The ProcessList uses the ToolList to get ToolNo

Now I want a data table named Repairs.
When uses selects the ToolNo how can I have the field named SetFor
(ProductNo) only show those values associated with the ToolNo the user
selected?
Would a query help here and how should it be made?

Excel was fun, Access is a challenge.

Thanks for your help, if you need more info please let me know

 

[Craig Hornish]

Ok I like a challange and interpreting what you have described is one
But that is the situation when you start out.

I decided not to assume anything (you may have issues with the tables you
have) but rather
describe a situaion that covers "show those values associated with the
ToolNo the user
selected? as it regards to a new table repairs"

If you have an Equipment table with an Equipment ID and a repair table that
describes repairs
to the Equipment.

tblEquipment tblRepairs
EqID rEqID
Name RepairsDone

There are a number of ways that this is done but most require a subform
for the Repairs.
That subform is put on a form that has another contorol (text, combo,
list another subform)
that can be used to select Equipment ID
The properties Link Child/Master Fields on the subform are then used to
associate that control
to the subform.
Link Child Field - rEqID
Link Master Fields - Me.txtEqID (that is the textbox on the form that
contains the Equipment ID)

I know this is not a complete answer but may help focus you to describe
exactly what you need.

--
Craig Hornish

Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"

 

[Sgwapt]

Craig,
Thank you for your assistance. This is about what I am looking for.
One table that contains the equipment list
Another table that contains the repair details
The subform i have played with looking at the sample db in help.

What i done in Excel is to create a list of part numbers (Products) when the
user selects the tool number (EqId). This way the users cannot select or
enter a part number against a repair (EqId) that does not belong to that tool
number.

Now I want to do this in Access but cannot seem to find the correct method
to make this list. Some tools have multiple products and some only have one.

Any thoughts will be helpful

Thanks