Help with designing a database to track information

[Chantale]

I need some help with designing a database to keep track
of information. I would be willing to send a copy of it
in order to get a better understanding of what I'd be
using it for. I have the fields done, but I need to
split it into tables and am not sure how to do this with
the info I have. Please let me know if you'd like to
give it a go. Thanks!!

 

[Duane Hookom]

Please take the time to be more specific. It would help if you typed in your
current table structure and a few records.

 

[Chantale]

This database is to keep track of records for an entirely
different database. Table 1 (Organization Table)Fields:
Organization Name, Address, City, Province, Postal Code,
Phone Number, Fax Number, Administrative Contact,
Category Code, Attachments. Table 2 (Service Table)
Fields: Record #, Service Name, Initial Data Request,
Request Comments, 2nd Request, 3rd Request, Exclusion
Date, Exclusion Comments, Partial Response Date,
Comments, Complete Response Date, Staff Sign-Off,
Attachments.

The idea is to keep track of the information as it is
updated for these organizations. I'm open to suggestions
on how to set this up. Initially I thought I could have
a linked field using the Organization Name so I only had
to input that I only had to input that once and it would
automatically up date in the Service Table but I haven't
been successful.

 

[Duane Hookom]

I would add an autonumber primary key field (OrgID) to your organization
table. Then add OrgID as a Long Integer field to the Service table. Take a
look at Tony's site regarding naming conventions etc
http://www.granite.ab.ca/access/tipsindex.htm