Thank You very much Mr. Browne you answered my question
to a tee... I have one more for you I am a very new
access programmer and I am putting together a database at
work I have been asking Mr. Ferguson another MVP on this
site for some assistance and He can go no further I am
having real trouble with the desgn model here is a copy
of what I posted hope you can help....

I am  trying to develop a access database version 2002
from scratch and I am a novice programmer and need much
direction. I have been researching  and studying about
relational database design and normalization  I am  
including the 9 tables and there fields that I have
already developed.  I have and I am not sure what to name
the tables and I am thinking of making the incident #
field the pimary key?? Can I put that in all  the tables?
I am determined to develop this and do it well. We are  a
Refuse Disposal site , is there any Disposal Management
Database examples  out there... If not can I get some
free advice and help in designing this database . Are my
tables looking okay? Can I use the( Incident # )as the
primary key for all the tables to connect them ? In one
of the tables I  want to put  digital pictures of the
dump sites can I develop a table for this to get them to
show up on the form..or do I need another database??
There are  about a 100 pic's.. in all.  I have to  scan
them in using the .bmp ext. is this okay???.  My OS is
Win Xp Home Editon and Office Xp Pro 2002 I only have 128
Mb memory..Do I need more? Here are the tables with the
fields: I have gathered the following information from
the 3 forms that the staff fills out by hand and then the
secretary takes 3months worth and then types them out to
look better.  I am confused on how to design the table
logic and make it relational

1.    Location/Name= This is  the name of the road or a
persons name
2.    Incident # = the number that it assign as they
are called in
3.    Directions from the court house= name of road
where site is
4.    Latitude and Longitude this is a question
5.    Dump Size =   (ft) Width x  (ft)Length x (ft)
Depth = (ft)to the 3rd power volume How do I make this a
field?
6.    How Many Single Axle  Dump truck loads ?
7.    Is there a well within 500 ft. of  an open dump ?
(this is a yes no box)
8.    Date Dumpsite Identified
9.    Date to Clean
10.    List any local schools or historic sites
11.    Responsible Party (yes/no)
12.    Enforcement actions Underway (Yes/No)
13.    County
14.    Nearest road   

Contents (All Yes/No Boxes) Do I make this a lookup box  
for all this?
1.    Household
2.    CD/D Building Material
3.    CD/D Concrete
4.    Brush/Landscape
5.    Appliances
6.    Tires
7.    Hazardous Material
8.    Other / List   

Accessibility  is another question with Y/N Boxes make
this lookups ?

1.    Paved
2.    Gravel/dirt
3.    steep slope
4.    trees surrounding site
5.    water surrounding site
6.    other/  List   

Type of setting  is another question with these
selections Y/N Boxes .

1.    Public Property
2.    flood plain/floodway
3.    open field
4.    sink hole
5.    cliff
6.    hillside
7.    woods
8.    creek/river
9.    old quarry pit
10.    roadside
11.    other/list

Digital Photos Table    I think I understand how to do
this? I found a  picture example within the Northwind
Database VB code under event procedure...i will work with
it. may have questions later

Equipment Cost is another field with these questions for
the surveyor
1.    Equipment Type has multiple listings under it
like bulldozer 8 different kinds also dump trucks,
backhoes just depends on what is needed to cleanup sites
2.    Max Hourly Rate = how much we charge for our
equipment use
3.    actual hourly rate= same as max
4.    hours used.
5.    total= a formula of actual x hours used

Disposal Fee = when the site is cleaned and the waste is  
hauled off and dumped at the main dump site (which by the
we have a contract with them) .
1.    Facility Name and location = where we dump it at
2.    Tons estimated = how much the load is on scales
3.    Per ton cost =
4.    total   

Labor Cost = this part of the form is where we figure our
labor cost for the job site.
1.    Employee Title= this is made up of 4 different
titles do I put this in a lookup box?
2.    estimated work hours
3.    hourly wage
4.    total   

Miscellaneous Supplies
1.    Specific Item
2.    quantity
3.    per unit cost
4.    total

Please help me with any advice as to line these out...
Thanks John