how do i make multiple relationship between tables

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

Guest

Below is the warranty particulars of a software inventory database, i'm
having problem in making tables and their relationships. so can somebody help
me out or give me any tips please. i'll be very thankful to u.

WARRANTY PARTICULARS
* Number of Years (Parts)
-Part
-Type (On Site?)
-Replacement (Y/N)
-Starting Date
-Expiry Date
* Number of Years (Parts)
-Type (On Site?)
-Starting Date
-Expiry Date
*Transportation
-Vendor's Responsibility
-JWT's Responsibility
*
-Backup Commitment (Y/N)
-Backup Level
--Same Configuration
--Lesser Configuration (Acceptable)
-Insurance Policy Reference
-Insurance Policy Expires on
 
Based on the information you gave it seems as if you need only one table,
'Warranty Particulars', and all of the categories listed subsequently should
be fields in the table.
 
Back
Top