Bad relationship......

chef_tim

Registered User.
Local time
Yesterday, 21:48
Joined
Dec 16, 2004
Messages
77
I'm stuck again. Here's the deal............ I have a data base to track training. I use three sets of forms to enter data Personnel info, training tasks, and carrer progression. I start out buy putting a new hire into the personnel info then update training through the other two forms. The problem is, when I add a new person the "training tasks" won't take any input. it is fine until I add someone. I checked the relationship between my tables, all show one to many, left joins. BUT when I open the properties for the training tasks query it shows a one-to-one #1 join type. If I make it a left join it then shows as a one-to-one. What have I done to deserve this???? Thanks in advance for any help, Tim
 
Sounds like you have the query joining on the wrong field in the many-side table. 1-1 joins occur when you join pk to pk. Since primary keys are unique, only one matching instance can occur in the child table. 1-m joins occur when you join pk to non-pk.
 
I tried all that, I have the SSAN as the primay on the personnel side and ID as the PK on the training side and SSAN is the join. Thanks Pat, Tim
 
Okay thinking of clearifying. The relationships are for a form that joins the personnel table to two tables (drivers training, carrer progression) and a query (training tasks). The query is the one I'm having the problem with, anyfield I try and enter data into just gives me a "dong". Hope that makes what I'm doing clearer. Thanks, Tim
 
The query is not updatable. You need to investigate why. There are lots of posts on the subject. You are probably using an aggregate function.
 
Here's what I'm thinking...........

This is/was my first attempt at major data base and I'm just getting confussed looking at some of my relationships and queries. I think I may just start the whole thing over but attack it from a more logical angle. I've started writing down the tables I want to include, and then I'll work my way up from there. This will also give me an oppertunity to create a uniform format. If anyone has any words of wisdom nows the time to speak up :o . Thanks, Tim
 

Users who are viewing this thread

Back
Top Bottom