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
rawley said:
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?
