Hi there,
Maybe I need more coffee or something but I cannot get my head around this.
I have a table called tblCandidates with will all candidates personal details in.
I also have a table called tblCandidateDrivingLicenceDetails which will contain all the Driving Licence details of candidates.
Now, some candidates will have driving licences. Others will not.
These tables are linked via the field 'Candidate ID'.
Basically I want to be able to have a form showing the tblCandidateDrivingLicenceDetails without creating it as a sub-form.
I want to be able to enter/view/edit information in the form as and when I want to due to some candidates not having driving licences.
Hope this makes sense. i have attached database.
Thanks
Maybe I need more coffee or something but I cannot get my head around this.
I have a table called tblCandidates with will all candidates personal details in.
I also have a table called tblCandidateDrivingLicenceDetails which will contain all the Driving Licence details of candidates.
Now, some candidates will have driving licences. Others will not.
These tables are linked via the field 'Candidate ID'.
Basically I want to be able to have a form showing the tblCandidateDrivingLicenceDetails without creating it as a sub-form.
I want to be able to enter/view/edit information in the form as and when I want to due to some candidates not having driving licences.
Hope this makes sense. i have attached database.
Thanks