Dear experts,
I keep struggling with cascading comboboxes.
The examples I find on the internet usually don't match my more complex requirement...
Can somebody please guide me and help me out.
I have a ton of excel files which I want to get rid off by using Access.
Hence I'm trying to create this dbse.
A brief description of what I'm doing:
I'm creating a database which will list all vessel we're managaging, I also want to keep track of changes in our fleet (like vessel
name changes, change of ownership... etc).
I started by giving all vessels an ID (TblVesselIDs).
Each vessel has an account code [VesselCompanyCodeID], a name with a 3 letter code [VesselNameCodeID], and IMO number [ImoID],
an owner [OwnerID] and an active/inactive status [VesselStatusID].
These 5 items make the vessel ID. Refer to attached picture VesselID.jpg
Example:
VesselID VesselcompanyCodeID VesselNameCodeID IMOID OwnerID VesselStatusID
001 780 MV Dolphin - DOL 123456 Neptune Ltd. active
002 785 MV LifterII 999999 Heavy Lifts Inc active
When either one of these 4 items change, then the present vessel ID is set to inactive and a new one is created.
Example:
VesselID VesselcompanyCodeID VesselNameCodeID IMOID OwnerID VesselStatusID
001 780 MV Dolphin - DOL 123456 Neptune Ltd. inactive
003 780 MV Whale - DOL 123456 Neptune Ltd. active
002 785 MV LifterII - LIF 999999 Heavy Lifts Inc inactive
004 800 MV LifterII - LFT 999999 Heavy Cargo Lifts Inc active
I do this so I can search and find things back.
A vessel can change: owner, name and code (rarerly IMO) over time. In above above example the MV Dolphin changed her name to MV Whale
and kept the same letter code as the owner remained the same. Before the code DOL she had code SHO and was named Seahorse.
So doing a search on SHO will result me the MV Seahores which would refer to a change name event to MV Dolphin.
If I would simply change the name then I don't have any record of the old name unless I add a field previous name but if a vessel
changes name 2 or 3 times then it becomes more complex to add this in the same table...
The other vessel information, like technical specifications, communciation details, crewlistings etc, I keep linked with IMO number
as that number won't change. So whenever an ID changes it stays linked with the other information based on the IMO number.
This tabel TblVesselID's has a relation with the tabel TblVesselManagementStatus which gives each vessel an operational status.
So each active vessel from TblVesselIDs has a status in TblVesselManagementStatus.
Refer to attached picuture VesselStatus.jpg.
VesselCurrentStatusID managementstatus: activitystatus: vesselstatus: eventstatus:
1 in management active sailing -
2 in management active sailing change
3 in management active sailing leaving
4 in management active sailing lay up
5 in management active joining take over
6 in management inactive warm -
7 in management inactive warm change
8 in management inactive warm leaving
9 in management inactive cold -
10 in management inactive cold change
11 in management inactive cold leaving
12 in management inactive under repairs -
13 in management inactive immobilized -
14 out of management inactive sold -
15 out of management inactive transferred -
And here's the part I'm stuck. I made a form FrmVesselManagementStatus where I want to be able to add/update the status of a vessel
by using comboboxes. Refer to attached picture FrmVesselManagementStatus.jpg.
Thanks for your help.
Best regards,
Siegfried
I keep struggling with cascading comboboxes.
The examples I find on the internet usually don't match my more complex requirement...
Can somebody please guide me and help me out.
I have a ton of excel files which I want to get rid off by using Access.
Hence I'm trying to create this dbse.
A brief description of what I'm doing:
I'm creating a database which will list all vessel we're managaging, I also want to keep track of changes in our fleet (like vessel
name changes, change of ownership... etc).
I started by giving all vessels an ID (TblVesselIDs).
Each vessel has an account code [VesselCompanyCodeID], a name with a 3 letter code [VesselNameCodeID], and IMO number [ImoID],
an owner [OwnerID] and an active/inactive status [VesselStatusID].
These 5 items make the vessel ID. Refer to attached picture VesselID.jpg
Example:
VesselID VesselcompanyCodeID VesselNameCodeID IMOID OwnerID VesselStatusID
001 780 MV Dolphin - DOL 123456 Neptune Ltd. active
002 785 MV LifterII 999999 Heavy Lifts Inc active
When either one of these 4 items change, then the present vessel ID is set to inactive and a new one is created.
Example:
VesselID VesselcompanyCodeID VesselNameCodeID IMOID OwnerID VesselStatusID
001 780 MV Dolphin - DOL 123456 Neptune Ltd. inactive
003 780 MV Whale - DOL 123456 Neptune Ltd. active
002 785 MV LifterII - LIF 999999 Heavy Lifts Inc inactive
004 800 MV LifterII - LFT 999999 Heavy Cargo Lifts Inc active
I do this so I can search and find things back.
A vessel can change: owner, name and code (rarerly IMO) over time. In above above example the MV Dolphin changed her name to MV Whale
and kept the same letter code as the owner remained the same. Before the code DOL she had code SHO and was named Seahorse.
So doing a search on SHO will result me the MV Seahores which would refer to a change name event to MV Dolphin.
If I would simply change the name then I don't have any record of the old name unless I add a field previous name but if a vessel
changes name 2 or 3 times then it becomes more complex to add this in the same table...
The other vessel information, like technical specifications, communciation details, crewlistings etc, I keep linked with IMO number
as that number won't change. So whenever an ID changes it stays linked with the other information based on the IMO number.
This tabel TblVesselID's has a relation with the tabel TblVesselManagementStatus which gives each vessel an operational status.
So each active vessel from TblVesselIDs has a status in TblVesselManagementStatus.
Refer to attached picuture VesselStatus.jpg.
VesselCurrentStatusID managementstatus: activitystatus: vesselstatus: eventstatus:
1 in management active sailing -
2 in management active sailing change
3 in management active sailing leaving
4 in management active sailing lay up
5 in management active joining take over
6 in management inactive warm -
7 in management inactive warm change
8 in management inactive warm leaving
9 in management inactive cold -
10 in management inactive cold change
11 in management inactive cold leaving
12 in management inactive under repairs -
13 in management inactive immobilized -
14 out of management inactive sold -
15 out of management inactive transferred -
And here's the part I'm stuck. I made a form FrmVesselManagementStatus where I want to be able to add/update the status of a vessel
by using comboboxes. Refer to attached picture FrmVesselManagementStatus.jpg.
Thanks for your help.
Best regards,
Siegfried
Attachments
Last edited: