PeterWieland
Registered User.
- Local time
- Today, 16:39
- Joined
- Sep 20, 2000
- Messages
- 74
I have searched for ages and can't find quite what I am looking for.
I want a subform, in table format, that expands depending on how many records there are. I will try to explain.
The parent form brings up the inventory record for a particular piece of equipment e.g. a desk lamp which has all the basic details (make, model, serial no, inventory number, purchase date etc.)
I then want a subform that will display all of the test results over time in a table. The rows will be the test results e.g. earth continuity, insulation resistance, leakage etc. Each column will be headed by the test date, with a final column for creating a new test record. This way I can see at a glance if a piece of equipment is starting to deteriorate.
This is something like what I am trying to acheive.
The built in tabular and datasheet layouts don't do exactly what I am looking for.
Thanks in advance for your help.
I want a subform, in table format, that expands depending on how many records there are. I will try to explain.
The parent form brings up the inventory record for a particular piece of equipment e.g. a desk lamp which has all the basic details (make, model, serial no, inventory number, purchase date etc.)
I then want a subform that will display all of the test results over time in a table. The rows will be the test results e.g. earth continuity, insulation resistance, leakage etc. Each column will be headed by the test date, with a final column for creating a new test record. This way I can see at a glance if a piece of equipment is starting to deteriorate.
Mar-17 | Mar-18 | Mar-19 | NEW TEST DATE | |
Visual (Pass/Fail) | Pass | Pass | Pass | |
Fuse (A) | 13 | 13 | 13 | |
Earth Continuity (Ω) | 0.054 | 0.057 | 0.058 | |
Insulation Resitance (MΩ) | >300 | >300 | >300 | |
Leakage (mA) | <0.30 | <0.30 | <0.30 |
This is something like what I am trying to acheive.
The built in tabular and datasheet layouts don't do exactly what I am looking for.
Thanks in advance for your help.