Re: beginner w/Relationship prblm
- From: "Brian Bastl" <bastl@xxxxxxxxxxx>
- Date: Fri, 10 Feb 2006 14:52:42 -0500
Hi Kegan,
Everyone here answering questions is a volunteer. AFAIK, nobody receives
tangible compensation for their contributions, although the MVPs might enjoy
some extra percs and/or recognition not afforded us mere mortals as a result
of their tireless efforts and infinite wisdom.
What is the purpose of the database? Your specific answer(s) will help
others help you to determine appropriate table structures and relationships
for your particular database.
Brian
"Kegan Longridge" <KeganLongridge@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:7D4D72BD-7B67-4B06-BFC2-4BCD8AF123FF@xxxxxxxxxxxxxxxx
I have a database with 3 levels.area)
District (which must have many areas)
Areas (which must have patrollers and contractors)
Patrollers and Contractors (which might do more than one job for each
.............................................................................
This is my third post and I haven't recieved any information which I could
understand. I am a begginner and need a walkthrough sort of explanation.
I currently have set up:
District table: (following are fields for this table)
-districtID-primary key
-districttype
Area/Patroller Table:
-areapatrol-primary key
-districtID
Area/Contractor Table:
-areacontractor-primary key
-districtID
(at this point you can tell that I have districtID-primary key related to
the distID in Area/Patroller and Area/Contractor tables)
Patroller Table:
-patrollerID-primary key
-areapatroller
-patrollername
-patrollertype
Contractor Table:
-contractorID-primary key
-areacontractor
-contractorname
-contractortype (areapatroller and areacontractor fields related back
to primary keys from areapatroller and area contractor tables)
.............................................
as
So here is the problem. I all the pat(patroller) and con(contractor)
records to relate to an area and then have the area relate back to a
district.
When I make a single form with many subcategories in order of district to
areapat/con and then pat/con it does not want to work and says errors such
cannot enter duplicate value and such.terminology,
If someone can help me in a beginner fashion and use very basic
explaining it during the way, I would be very greatful.
Thank you for any help you can give, "especially you volunteers"
.
- Prev by Date: Table design for Inventory Management
- Next by Date: Re: new user! Can anyone create this somewhat simple database?
- Previous by thread: Table design for Inventory Management
- Next by thread: RE: beginner w/Relationship prblm
- Index(es):
Relevant Pages
|
