Steve_Geary
New member
- Local time
- Yesterday, 18:54
- Joined
- Nov 12, 2012
- Messages
- 3
Hi,
I've been given the task of creating a db to replace an overworked spreadsheet.
The db is going to store life information about power supplies that have been put on long-term 'soak'.
The tables I've created are:
tblPSU:- Specific information on the PSU, i.e. ID, Batch number, part number, nominal voltage & current, date soak started, date soak ended, load value, active (yes/no) and a big text field for any observations.
tblBatch:- Specific batch information, i.e. batch quantity, supplier, date received and reason for test
tblSuppliers:- a look-up table for tblBatch/Supplier
I've got a form that allows entry of batch info that includes a cut-down tblPSU, so the operator can enter initial details of the individual units within the batch, with a button that opens a second form to enter detailed unit information.
The second form opens showing the data for unit 1, whereas I'd like it to open showing the first unit of the current batch. I'm sure this shouldn't be too difficult, but it is eluding me at the moment.
Any help would be gratefully recieved
Ta Steve
I've been given the task of creating a db to replace an overworked spreadsheet.
The db is going to store life information about power supplies that have been put on long-term 'soak'.
The tables I've created are:
tblPSU:- Specific information on the PSU, i.e. ID, Batch number, part number, nominal voltage & current, date soak started, date soak ended, load value, active (yes/no) and a big text field for any observations.
tblBatch:- Specific batch information, i.e. batch quantity, supplier, date received and reason for test
tblSuppliers:- a look-up table for tblBatch/Supplier
I've got a form that allows entry of batch info that includes a cut-down tblPSU, so the operator can enter initial details of the individual units within the batch, with a button that opens a second form to enter detailed unit information.
The second form opens showing the data for unit 1, whereas I'd like it to open showing the first unit of the current batch. I'm sure this shouldn't be too difficult, but it is eluding me at the moment.
Any help would be gratefully recieved
Ta Steve
