A question regarding a field and a form with multiple inputs for the product

[RoundTrip]

Alright everyone, last question of the night for me! And thank you everyone in advanced. Here is my information
I have two tables, one for all the information concerning certain equipment, how many hours was put on the equipment, the date the equipment was used and a workorder number(number that distinguishes that job from another job and also on this table workorder number is primary key)

My other table is a table with also workorder number (which on this table is fk), location of the job, products used, and some averaging which i have figured out
Now my question is on the second table i have multiple products that must be entered for just that one work order, for example if lets say I use the following things on the job

Oil, filter, gasket, and adhesive, i would need all those entered


So how would I go about doing this? Or could I do this in a form and if so how?
I hope that makes sense, if I need to clarify on something please ask me, and thankyou.
OR is it possible when I open a form, it ask me how many products I used for that job and it pops up with that many blanks for me to fill in on product, and it automatically fills the rest in for me such as workorder number, location etc based off the first record it pertains to?

[June7]

Is this equipment being used on a job, not equipment being repaired?

Consider:

tblEquipment
EquipID (PK)
EquipName

tblWorkOrder
WOID (PK)
WODate
Location

tblWO_Equip
WOID (FK)
EquipID (FK)
Hours

tblPartsSupplies
ItemID (PK)
ItemDesc
ItemUnit (ea, gal, lb, etc)

tblWO_PartsSupplies
WOID (FK)
ItemID (FK)
Quantity

[RoundTrip]

It's being used to determine what was used on the job on lets say this date at this location.
Possibly a listbox? Or would that not be a smart move in your opinion?
But by the way your explaining it, i will have to manually type in the criteria for the products anyways huh

[June7]

I edited my prior post maybe while you were posting. Is your question still relevant?

I use listbox for data entry only if it is a short list, otherwise combobox.

[RoundTrip]

Actually yes...it is actually very relevant!

[June7]

Then sorry, don't really understand the question.

tblEquipment and tblPartsSupplies are source tables for data to populate records in the other tables. Yes, will need to create records in these 2 tables first. Entering them on-the-fly while entering data in other tables is possible - with code.

[RoundTrip]

Alrighty , thankyou I think I understand where you were going with the first post,