Hello!
I have a table (tblInfo) which has columns like ID(Autonumber), FirstName, LastName, DOB, Email, etc.
I need to have a child table (tlbcerts) to this that automatically fills in part of the records required for certain certificates.
For example, in tblInfo I have a record like 1, Joe, Bloggs, 01/01/80, joe.bloggs@gmail.com This information is entered via data entry form.
I need then to have a subform on the data entry form, which when a button is pressed tlbCerts opens up 9 preset records which correspond and are linked with the tblInfo.
So when I click the button in the subform it will always open 9 records which would look similar to the below:
PersonID FirstName LastName Cert CertNumber Expiry
The idea is that the PersonID is the same as the person just entered in tblInfo, this then also puts in the corresponding FirstName and LastName from the data just entered in tblInfo, this will then be the same for the next 9 preset records for each certificate, the user then has to enter the CertNumber and ExpiryDate.
So when you click on the button in the subform it will automatically make the tblCert look something like this:
1, Joe, Bloggs, AAA
1, Joe, Bloggs, BBB
1, Joe, Bloggs, CCC
1, Joe, Bloggs, DDD
1, Joe, Bloggs , EEE
Then the user can simply enter the cert number and expiry date for each of the certificates for that person.
I hope that makes sense, quite difficult to explain it properly!! :banghead:
I have a table (tblInfo) which has columns like ID(Autonumber), FirstName, LastName, DOB, Email, etc.
I need to have a child table (tlbcerts) to this that automatically fills in part of the records required for certain certificates.
For example, in tblInfo I have a record like 1, Joe, Bloggs, 01/01/80, joe.bloggs@gmail.com This information is entered via data entry form.
I need then to have a subform on the data entry form, which when a button is pressed tlbCerts opens up 9 preset records which correspond and are linked with the tblInfo.
So when I click the button in the subform it will always open 9 records which would look similar to the below:
PersonID FirstName LastName Cert CertNumber Expiry
The idea is that the PersonID is the same as the person just entered in tblInfo, this then also puts in the corresponding FirstName and LastName from the data just entered in tblInfo, this will then be the same for the next 9 preset records for each certificate, the user then has to enter the CertNumber and ExpiryDate.
So when you click on the button in the subform it will automatically make the tblCert look something like this:
1, Joe, Bloggs, AAA
1, Joe, Bloggs, BBB
1, Joe, Bloggs, CCC
1, Joe, Bloggs, DDD
1, Joe, Bloggs , EEE
Then the user can simply enter the cert number and expiry date for each of the certificates for that person.
I hope that makes sense, quite difficult to explain it properly!! :banghead: