Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Towed Vehicles Towing Companies Contact Persons Tow Types
tblTowId tblTowCompanyID tblContactID tblTowTypeID
tblTowDateRequest tblCompanyName tblLastName tblTowType
tblTowTimeRequest tblAddress tblFirstName tblTowID
tblTowLocation tblCity tblBusPhone
tblTowDateArrival tblZipCode tblCellPhone
tblTowTimeArrival tblContactID tblTowCompanyID
tblTowTypeID tblBusPhone tblNickname
tblReportNumber tblFaxNumber tblFaxNumber
tblTowCompanyID tblTowID tblOtherNumber
tblTowCompany

These are the tables I believe I need to start this database in regards to a
Towing Vehicle Database I have to make for our police dept. ( I wish there
was a way to color code some of the fields to make this easier.) I don't
know if I figured these tables right.
I tried to make a 1-M relationship from tblTowId in Towed Vehicles Table to
tblTowID in Towing Companies Table.
Then a 1-M rel. from tblTowCompanyID in Towing Companies Table and
tblTowCompanyID in Contact Persons Table.
Then a 1-M rel. from tblTowId in Towed Vehicles Table and tblTowId in Tow
Types table.

Is this correct?
 
You had too many fields ---
Towed Vehicles Towing Companies Contact Persons Tow Types
tblTowId tblTowCompanyID tblContactID tblTowTypeID
tblTowDateRequest tblCompanyName tblLastName tblTowType
tblTowLocation tblAddress tblFirstName
tblTowDateArrival tblCity tblBusPhone
tblTowTypeID tblZipCode tblCellPhone
tblReportNumber tblContactID tblTowCompanyID
tblTowCompanyID tblBusPhone tblNickname
tblFaxNumber tblFaxNumber
tblOtherNumber
This was pasted from Excel so you need to paste back in Excel to view.
You do not need separate date and time fields.
When you have a one-to-many relation you do not need the 'many' primary key
as a foreign key in the 'one' table.
You do not need the tblTowCompanyID and tblTowCompany in the tow table.
To display the company you have both tables in the query but not have the
tblTowCompanyID as an output field.
 
Towed Vehicles Towing Companies Contact Persons Tow Types
tblTowId tblTowCompanyID tblContactID tblTowTypeID
tblTowDateRequest tblCompanyName tblLastName tblTowTypetblTowTimeRequest tblAddress tblFirstName tblTowID
tblTowLocation tblCity tblBusPhone
tblTowDateArrival tblZipCode tblCellPhone
tblTowTimeArrival tblContactID tblTowCompanyID
tblTowTypeID tblBusPhone tblNickname
tblReportNumber tblFaxNumber tblFaxNumber
tblTowCompanyID tblTowID tblOtherNumber
tblTowCompany
Click to expand...

Dude, you've got things wildly wrong!

You start you TABLES with tbl! Stan Leszynski will be turning in his
grave!!

Fields should start with their data types, 'dat' for date, 'tim' for
time, 'vbn' for varying binary, ID for autonumber (go figure) etc For
text, use ftx for fixed width text, vtx for varying text, then you add
'usa' to show you're using WITH COMPRESSION to use ASCII (where the A
stands for u s of A) unless your using Unicode when you have to add
'fra' to show you're a Francophile LOL And if your using one of the
new multivalued types in Access 2007 you have to add nfnf ROFL
 
KARL DEWEY said:
You had too many fields ---
Towed Vehicles Towing Companies Contact Persons Tow Types
tblTowId tblTowCompanyID tblContactID tblTowTypeID
tblTowDateRequest tblCompanyName tblLastName tblTowType
tblTowLocation tblAddress tblFirstName
tblTowDateArrival tblCity tblBusPhone
tblTowTypeID tblZipCode tblCellPhone
tblReportNumber tblContactID tblTowCompanyID
tblTowCompanyID tblBusPhone tblNickname
tblFaxNumber tblFaxNumber
tblOtherNumber
This was pasted from Excel so you need to paste back in Excel to view.
You do not need separate date and time fields.
When you have a one-to-many relation you do not need the 'many' primary key
as a foreign key in the 'one' table.
You do not need the tblTowCompanyID and tblTowCompany in the tow table.
To display the company you have both tables in the query but not have the
tblTowCompanyID as an output field.
Click to expand...
 
Back
Top