Help with Table structure

[faradhi]

I have an Access Database for that aids in Parking Management for a small college. In the Database I have two tables.

The first is table tblLots, which holds the Lots that are managed, has the following fields:

LotID
LotDesc

The Second Table tblCustType, which holds a type of customer, has the fields:

TypeID
TypeDesc

In the database, I would like to record in which lot each customer type may park. For example, Students may park in Lot A.

I can think of three ways of accomplishing this task.

One is a third table that records the LotID and the TypeID for each lot that customer type may park in.

The second is to have a true\false field for each lot in tblCustType.

The third is to have a true\false field for each CustomerType in tblLot.

I am using a ASP to access the Database.

What would be the best method for recording in which lot each customer type may park?

 

[The_Doc_Man]

The scrupulously correct method would be a linking table.

The problem with True/False fields in either of the other tables is that if you define a new permit type or add a new property to your parking area (or merely re-designate one) you have a massive problem in updating. But with a linking table, adding a new type or new lot doesn't hurt anything.

 

[faradhi]

That is what I thought.

Thanks for the confirmation and quick reply.

Bryan