Forms - hope to find a patient teacher... (1 Viewer)

Hi everyone, I tried searching and really couldn't find answers...
I built my first DB and could really use help...
I have 7 tables, and will soon need to add a few more... I tried to break
them down the best I knew how. I had to make them a bit generic because
my company is serious about not sharing data... (sorry)

My goal was an easy first learning DB, yeah, not so much, not for me
anyway... I wanted to make a DB to contain, query and also build forms
that would update data in all tables. My practice queries all seem to run
okay, and I think I have my relationships correct... I used the location table
as the main table that all other tables link to... (question, I want to ERI all relationships, and my joins are all set never to drop lines from tbl-
LOOK_Location (not sure if it's right or left join...?). I ran a query of all
data that I would want to be entered when a new location is added and
produced a form from that, I also tired to build a form from the wizard,
adding cells in the order I wanted from each of the tables (with the
exception of duplicates and autonumber items that I thought would update
on their own.) Now I have join errors, "cannot add records; join key of
table (in whichever table the cell I am trying to update) not in record set."
If I change the joins those items will allow entry. But I dont know how to
fix it...

Tables:

tbl_LOOK_City_Name
City ID=(auto#)
City name
Location_ID
ServType ID
tbl_LOOK_Contact
Location
Location ID=(auto#)
Contact Name
Office Phone
Extension
Fax#
Email
Cell Phone
Other Phone
tbl_LOOK_(Manager)
Manager ID
Manager
Team ID
tbl_LOOK_Location
Location ID=(auto#)
Location
Address
City
State
Zip
Manager ID
Team ID
Active location (Y/N)
tbl_LOOK_MFG_Codes
Location ID
City Name ID
Service Type ID
Code 1
Code 1 (active Y/N)
Code 2
Code 2 (active Y/N)
Labor Rate
tbl_Serv_Type
ServType ID
Service Type (there are 4 types)
tbl_LOOK_Team
Team ID (auto#)
Team (there are 5 and probably won't grow)
Manager ID

Can you help me understand?
Thank you so very much.
Debi

Insert some spaces, carriage returns and blanks lines, both in your text and list of table, to keep things together that should be kept together and to separate those that shouldn't ... we get hit by one mass of black.

For reference:

Do not use embedded spaces in Access field or object names.
Use a naming convention that uses only alphanumeric characters and "_" underscore.

It will save you from frustration with syntax errors.

And before you get too involved in Access, work through this tutorial to experience and learn database concepts. You can use what you learn in future projects.

You may find this thread interesting.

Good luck.