Relationships Problem

[willbo987]

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

 

[jdraw]

Can an individual Candidate have more than 1 drivers license?
Does a Foreign license have similar "Classes" eg B, BE , C1, C1E....?

 

[willbo987]

Hi jdraw thanks for your reply.

No. If they have one, some wont, they would only ever have 1.

Thanks

 

[jdraw]

A Candidate may have 0 or 1 License (could be a NULL value)
A License may be Foreign or Domestic
A License is of 1 LicenseType ( B, BE , C1, C1E...)
A License has 1 LicenseNumber

I would advise you not to use field names with embedded spaces. Use alphanumeric and "_" underscore only.

 

[willbo987]

If a candidate has a driving licence, they will have 1 licence number which will be either foreign or domestic. However, they may have more than one licence type.

For example, one licence may cover more than one category of vehicle.

 

[jdraw]

A Candidate may have 0 or 1 License (could be a NULL value)
A License may be Foreign or Domestic
A License is of 1 or many LicenseCategory/ies ( B, BE , C1, C1E...)
A License has 1 LicenseNumber