I
ironwood9 via AccessMonster.com
I have a form whose source is a table containing projects (tblProjects), and
several vendors do work on each project - I have a subform that lists the
vendors, which I want to be able to input information for, "on the fly,"
while the form is running. One key field to be input is insurance type for
the insurance liabilty forms needed for the projects. My users are manually
inputting the insurance type in the subform, but I want them to be able to
select from a list, without completely re-designing the form.
My design is basic, like:
tblProjects
=======
ProjectID (PK)
VendorID (FK)
InsTypeID (FK)
ProjectName
tblVendors
========
VendorID (PK)
VendorName
tblInsType
=========
InsTypeID (PK)
InsType
... would a combo box work, or would I need coding, and what would the syntax
be ?
Any help would be greatly appreciated
several vendors do work on each project - I have a subform that lists the
vendors, which I want to be able to input information for, "on the fly,"
while the form is running. One key field to be input is insurance type for
the insurance liabilty forms needed for the projects. My users are manually
inputting the insurance type in the subform, but I want them to be able to
select from a list, without completely re-designing the form.
My design is basic, like:
tblProjects
=======
ProjectID (PK)
VendorID (FK)
InsTypeID (FK)
ProjectName
tblVendors
========
VendorID (PK)
VendorName
tblInsType
=========
InsTypeID (PK)
InsType
... would a combo box work, or would I need coding, and what would the syntax
be ?
Any help would be greatly appreciated