K
Kelly S
Sorry for the length of the question but I've gotten myself completely
confused on which method I should be trying to use in order to get the proper
results from my database. I don't know if I'm using the wrong method or
perhaps have a problem in the relationships.
The end objective here is to input Project information and then run reports
which will select qualified Suppliers based on the requirements of the
Project. --
Here is a breakdown of where I am stuck.
I have the following tables: Project Info, Supplier Info, Equipment Type,
and Manufacturer Info.
One Manufacturer carries several Equipment Types. One Supplier carriers
several Equipment Types of various Manufacturers. One Project will require
specific Equipment Types from specific Manufacturers.
I have one to many relationships as follows:
Project Details: ProjectID, TypeID, ManfID
Supplier Details: SupplierID, TypeID, ManID
Manf Details: ManID, TypeID
What method do I use on my forms in order to populate my details correctly?
When dealing with the Project Details form I need to be able to select
equipment types and their related manufacturer types. For example I need an
Air Handler by Carrier or Trane and a Boiler by Carrier. When I select Air
Handler I want to list only the Manufacturers that make Air Handlers and be
able to make multiple selections of Manufacturers. The Manufacturer
selection should be limited by the Manf Details table.
When dealing with Supplier Details form I need to be able to make a similar
selection. One supplier may carry Air Handlers by Trane and Boilers by
Carrier. (Note although they carry Carrier they don't carry Air Handlers by
Carrier.) The Manufacturer selection should be limited by the Manf Details
table.
When dealing with Manufacturers form I need to be able to select all of the
equipment types that they make. I.E., Carrier makes Air Handlers and
Boilers, Trane makes Air Handlers.
Do I have the correct relationships?
Should I use comboboxes, listboxes, and/or subforms to accomplish the above
selection process?
Any help in getting me on the right path would be greatly appreciated!!
Kelly S
confused on which method I should be trying to use in order to get the proper
results from my database. I don't know if I'm using the wrong method or
perhaps have a problem in the relationships.
The end objective here is to input Project information and then run reports
which will select qualified Suppliers based on the requirements of the
Project. --
Here is a breakdown of where I am stuck.
I have the following tables: Project Info, Supplier Info, Equipment Type,
and Manufacturer Info.
One Manufacturer carries several Equipment Types. One Supplier carriers
several Equipment Types of various Manufacturers. One Project will require
specific Equipment Types from specific Manufacturers.
I have one to many relationships as follows:
Project Details: ProjectID, TypeID, ManfID
Supplier Details: SupplierID, TypeID, ManID
Manf Details: ManID, TypeID
What method do I use on my forms in order to populate my details correctly?
When dealing with the Project Details form I need to be able to select
equipment types and their related manufacturer types. For example I need an
Air Handler by Carrier or Trane and a Boiler by Carrier. When I select Air
Handler I want to list only the Manufacturers that make Air Handlers and be
able to make multiple selections of Manufacturers. The Manufacturer
selection should be limited by the Manf Details table.
When dealing with Supplier Details form I need to be able to make a similar
selection. One supplier may carry Air Handlers by Trane and Boilers by
Carrier. (Note although they carry Carrier they don't carry Air Handlers by
Carrier.) The Manufacturer selection should be limited by the Manf Details
table.
When dealing with Manufacturers form I need to be able to select all of the
equipment types that they make. I.E., Carrier makes Air Handlers and
Boilers, Trane makes Air Handlers.
Do I have the correct relationships?
Should I use comboboxes, listboxes, and/or subforms to accomplish the above
selection process?
Any help in getting me on the right path would be greatly appreciated!!
Kelly S