HalcyonDaze
New member
- Local time
- Today, 04:03
- Joined
- Aug 12, 2010
- Messages
- 8
I have a Form to make, and I have only done the most basic of form work in the past. Honestly I dont even know enough to use the proper terms when asking this question, but Ill do what I can:
I have an existing Table A in my db. Each record corresponds to an instrument being installed in a job, and is labeled using a combo of fields: Area, Tag Prefix (textual), Tag (numeric), and Tag Suffix (textual), so an instrument might be labeled PV-18B in Area 200.
Table B is a 1-1 table to A and is being used to construct Datasheets for each instrument. Each each datasheet will have 64 fields of data related to the spec settings of the instrument.
The Category labels of those 64 fields in the datasheet will differ based on the type of instrument (which is stored in Table B). The type is a field in B and the category names themselves are stored in a third Table C.
Now, I already have a query and report that will gather all this info together and print it out, with one sheet per instrument, data from B filled in, with Tag labels from A, and Spec Categories from Table C.
Now I am trying to make a Form to make Data Entry easy. Ideally, I would have a sheet that looks like the 1-page Report, with combo box controls at the top to point the data to a specific, pre-existing record in Table 1 and another Combo box control to select the Instrument type (which would then automatically populate the Spec categories). Then you just have to go through the 64 fields and fill in the different settings as needed.
If I have to break these functions into separate windows (sub-forms?), so there is a separate screen for record/instrument selection and for setting entry, Im open to it.
Any suggestions for a n00b as to how to go about this?
I have an existing Table A in my db. Each record corresponds to an instrument being installed in a job, and is labeled using a combo of fields: Area, Tag Prefix (textual), Tag (numeric), and Tag Suffix (textual), so an instrument might be labeled PV-18B in Area 200.
Table B is a 1-1 table to A and is being used to construct Datasheets for each instrument. Each each datasheet will have 64 fields of data related to the spec settings of the instrument.
The Category labels of those 64 fields in the datasheet will differ based on the type of instrument (which is stored in Table B). The type is a field in B and the category names themselves are stored in a third Table C.
Now, I already have a query and report that will gather all this info together and print it out, with one sheet per instrument, data from B filled in, with Tag labels from A, and Spec Categories from Table C.
Now I am trying to make a Form to make Data Entry easy. Ideally, I would have a sheet that looks like the 1-page Report, with combo box controls at the top to point the data to a specific, pre-existing record in Table 1 and another Combo box control to select the Instrument type (which would then automatically populate the Spec categories). Then you just have to go through the 64 fields and fill in the different settings as needed.
If I have to break these functions into separate windows (sub-forms?), so there is a separate screen for record/instrument selection and for setting entry, Im open to it.
Any suggestions for a n00b as to how to go about this?
