Setting up Multiple tables/relationships

[BartK]

Hello everyone,
I feel like I am ice skating uphill here. I have something I'm working on and I need some advice to see if I'm doing it the correct way or if there is a better way. I will attach a copy so you can see what I'm trying to explain.

I have 5 tables and 2 forms. The primary form is what I input all the information into (Tracking) and the other form is to update employee information (update form).

The "Tracking" form is where I add information to 4 of the 5 tables. Here is where I'm stumbling. Would it be more practical to just have 1 table and just expand the fields, or have the form put the information into the separate tables. Those 4 tables are Employee, phone, spotter and radio.

I'm wanting to keep a running tally of who doesn't turn in what equipment on what day.

The last form is something that I can work on later. I want to make sure I have a good foundation first before I move forward. Thank you for all the help.

 

[Mihail]

If you will save your DB in an older version of Access (best is 2003) you will gain more help.

 

[gbnz]

Hi Bart,

Looking are your Tables...it seems to me that you have 2 main tables and 3 tables that hold multiple items. Here is how I would set up this Database.

tblEmployee
EmployeeID (PK)
LastName
FirstName
EmployeeNo
Crew
RecDate

tblPhone
EmployeeID
Phone
PhoneDate
PhoneID (PK)

tblRadio
EmployeeID
Radio
RadioDate
RadioID (PK)

tblSpotter
SpotterType
SpotterName
SpotterDate
SpotterID (PK)

Now your one to many relationships will run from tblEmployee.EmployeeID to tblPhone.EmployeeID and tblRadio.EmplyeeID and tblSpotter.EmployeeID.

 

[BartK]

I am having troubles on the form in design view. The text boxes I cannot get them to store the information in the correct table. I am trying to change it in the control source, however it gives me a ! in a yellow box. Like I said I am very new when it comes to multiple tables. Thanks again.