fsupport1600
MIS
Can anyone provide some help with a basic database I am trying to develop.
The database is going to be used to select furniture for classrooms in a building. So I have created a table that contains the room name and room numbers. Another table that contains the product information for each piece of furniture, and another one which I called Order Details that includes the product data and input for quantities.
What I would like to do now is, create a form that allows the user to select the room number from a drop down list and within that same form display a sub form related to that room where they can select the pieces of furniture and the number they need for that piece of furniture. Each room is going to have multiple pieces of furniture so each row in the sub form will represent a different type of furniture.
I have added a link to my file.
I have been looking at examples and running through a few different tutorials but I just can get it to work out right.
Any help is appreciated.
The database is going to be used to select furniture for classrooms in a building. So I have created a table that contains the room name and room numbers. Another table that contains the product information for each piece of furniture, and another one which I called Order Details that includes the product data and input for quantities.
What I would like to do now is, create a form that allows the user to select the room number from a drop down list and within that same form display a sub form related to that room where they can select the pieces of furniture and the number they need for that piece of furniture. Each room is going to have multiple pieces of furniture so each row in the sub form will represent a different type of furniture.
I have added a link to my file.
I have been looking at examples and running through a few different tutorials but I just can get it to work out right.
Any help is appreciated.
