Help on layout please

ExpandCollapse

Guest

Hello

I am looking for the best table layout to keep track of a person that
is a transporter for my organization. With that I will also need to
keep track of the vehicle(s) they will be using, the LicensePlate
number(s) of the vehicle(s), Insurance Policy covering that vehicle,
transporters drivers license number.

TBL-LicensePlateEvent(LicensePlateEventID, LicensePlateID,
TransporterID, StateOfIssue, DateOfIssue, DateExpire)
**Note: I broke the License Plate into two tables, for in some states,
you get a different plate number yearly or every 5 years, and I would
like to retain the tag history of each transporter**

TBL-DriverLicense(DriverLicenseID, DriverLicenseNumber, TransporterID,
StateOfIssue, DateOfIssue, DateExpire, CopyOnFile)
**Question: Since a person's DL number may also change, should I break
this table down... not sure on best way**

About Us

Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Like us on Facebook

Support SPN

The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. We'd really appreciate your support!