I am not sure if I will be able to explain this correctly however; I am building a Bill of Materials app for conference room buildouts. I have the following tables:
- Room Types
- AV Equipment
- VC Equipment
- Services
- Room Standards
It is within the Room Standards table where I am trying to pull up a Room Type from the Room Type table then add AV Equipment, VC Equipment and Services...all of which pulling from their respective tables. Issue is, there are usually more than one item needed per table.
Example: A Small Conference room type may have 2 AV items and 2 VC items and 3 services.
Based on this example, what I am hoping to achieve with the Room Standards table is to create a static set of equipment and services for that room type.
Exampe: If a user selected Small Conference room, all of the items that were added above would come up. From there I could create a report i.e. Bill of Materials with various room types and each would have their list of items associated
Long explanation and it might be confusing but how can I get the multiple items added on a form within the Room Standards table?
------------------------------
Charles Wade
------------------------------
