having problem with table

[rawley]

I have the following tables: An Equipment Type table which denotes things like mixers, dust collectors, forklifts, etc. Then, I have an Equipment table (with a link between the Type ID of the previous table) that lets me use a pulldown to select a Type of 'Forklift' and then to enter specifically #1 ABC Forklift, etc. All this works fine. I want to use this data to enter information in when we do work on the forklifts, including the hours worked on the forklift. I want the table to have a pulldown from the Equipment table so that I can select which forklift was worked on. I tried linking the Equip Name field, but the best I can do is that all equipment shows up in the pulldown. I only want equipment that is a Forklift type. Any ideas on this one, or can I structure it a different way

Thanks!

 

[tina]

I want the table to have a pulldown from the Equipment table

recommend you *don't* put a pulldown in the table, in any table. do your
data entry in forms, not directly in tables, and create combo boxes as
needed in the forms. for details on why you shouldn't use Lookup (pulldown)
fields in tables, see the following link:

http://www.mvps.org/access/lookupfields.htm

to solve the issue you describe below: *in a form* bound to
"tblEquipMaintenance", you need some way to tell the system what type of
equipment you want to track at any given time. one way is to create an
unbound combo box based on tblEquipmentType. after you set it up, you need
to add a macro or event procedure on the control's AfterUpdate event, to
requery the "Equipment Name" combo box.
in your Equipment Name combo box, click the builder (...) button on the
RowSource, to open the design window. add the Equipment Type field to the
design grid, at the end. *uncheck the checkbox in that column.* add the
following criteria to that column:

Forms!FormName!EquipmentTypeControlName

when you open the form to add a maintenance record, start by selecting the
equipment type from the unbound combo box.
now the Equipment Name combo will be requeried, to list only equipment that
matches the type you selected.

hth

I have the following tables: An Equipment Type table which denotes things

like mixers, dust collectors, forklifts, etc. Then, I have an Equipment
table (with a link between the Type ID of the previous table) that lets me
use a pulldown to select a Type of 'Forklift' and then to enter specifically
#1 ABC Forklift, etc. All this works fine. I want to use this data to
enter information in when we do work on the forklifts, including the hours
worked on the forklift. I want the table to have a pulldown from the
Equipment table so that I can select which forklift was worked on. I tried
linking the Equip Name field, but the best I can do is that all equipment
shows up in the pulldown. I only want equipment that is a Forklift type.
Any ideas on this one, or can I structure it a different way?