Hi,
I'm designing a database which is used for calculating prices per transporter. Each transporter is assigned a unique code (in table tblCarriers) and can transport from a specific country. When a transporter can transport from country, this country has to be linked to this specific transporter.
In the current design each transporter is assigned a value of power two, so {1,2,4,8,......,n} in tblCarriers. Table tblZones consists of all countries and contains one column called departurePossible. When a transporter can transport from a country, the value which is assigned to that specific transporter of power two is added to the departurePossible column.
If ((tblZones.departurePossible.value And tblCarriers.value) = tblCarriers.value)
Then
departurePossible = True
This works, but the values of power two grow exponentially which isn't favorable. Does anyone has other ideas for managing this kind of problems?
Thanks in advance.
I'm designing a database which is used for calculating prices per transporter. Each transporter is assigned a unique code (in table tblCarriers) and can transport from a specific country. When a transporter can transport from country, this country has to be linked to this specific transporter.
In the current design each transporter is assigned a value of power two, so {1,2,4,8,......,n} in tblCarriers. Table tblZones consists of all countries and contains one column called departurePossible. When a transporter can transport from a country, the value which is assigned to that specific transporter of power two is added to the departurePossible column.
If ((tblZones.departurePossible.value And tblCarriers.value) = tblCarriers.value)
Then
departurePossible = True
This works, but the values of power two grow exponentially which isn't favorable. Does anyone has other ideas for managing this kind of problems?
Thanks in advance.