JustMargie
JustMargie
- Local time
- Today, 14:38
- Joined
- Oct 26, 2010
- Messages
- 4
I have a db designed for performing cleaning/custodial inspections. The main table (AllInspectionsTbl) contains the general information; which building is being inspected, who cleaned it, date... etc. Another related table(InspDetailTbl) contains the inspection details: TaskID (numbered from 1-61), Tasks (The description of each task), Score (numeric field from 1-5) and a text field for comments. The primary key on the AllInspectionsTbl is InspID (auto-numbered). The primary key on the inspection details table is InspDetailID (also auto-numbered). InspID is a foreign key on the InspDetailTbl
Modeling this after the Northwind Trader's db, I thought of these tasks like the products in NWT db. I have created a form with a sub-form based on each tables. The main form is not a problem. But, for the sub-form, I would like all the tasks to appear - unlike the Northwind db where the products are selected from a drop down list.
Is there a control that I can add either to the main form or the sub-form which will cause all of the TaskID's and Task Descriptions to auto-fill so that the user just needs to enter a score?
Modeling this after the Northwind Trader's db, I thought of these tasks like the products in NWT db. I have created a form with a sub-form based on each tables. The main form is not a problem. But, for the sub-form, I would like all the tasks to appear - unlike the Northwind db where the products are selected from a drop down list.
Is there a control that I can add either to the main form or the sub-form which will cause all of the TaskID's and Task Descriptions to auto-fill so that the user just needs to enter a score?
