View Single Post
  #1  
Old March 30th, 2010, 01:12 AM posted to microsoft.public.access.tablesdbdesign
Ron A.
external usenet poster
 
Posts: 50
Default Table Structure Help

I am needing some assistance in creating a solid table structure in creating
a database that stores vehicle permenant waiver items (items that will not be
repaired) and produce a report showing waivers for a specific vehicle or
organization. Specifics are as follows:

- 1 organization has a master Org Code
- an organization can have many sub Org Codes (multiple shops in 1 org)
- an organization can have many Vehicle Control Officers (usually 1 per sub
Org Code)
- Vehicles are assigned to master org code and sub org codes
- One vehicle can have many waivered items

I hope I have explained this well enough.

Thanks,
Ron A.