Indeterminate Relationship

[johnnyguy]

Hi i have just joined and am having trouble linking 2 tables with composite primary keys. The relationship type i want is 1 to many but it only allows indeterminate and wont allow any cascading! the field in question (Class_No) looks to be the same in both tables the only difference is it is a composite key of 5 in 1 table and 2 in the other i have attached a screenshot if u dont know what i mean. Please help.

Thanks

CJ

 

[Pat Hartman]

The picture quality is way too poor to read. So, I'm going to guess that the problem lies with how the primary keys of the tables are defined.

composite key of 5 in 1 table and 2 in the other

- I don't know what you mean by this. If you have a composite key that includes 5 columns in one table, how can it include only 2 in the other. If by that you mean that some of the fields are concatenatec, I'm afraid you'll have to change the design and separate the columns into their atomic values.

 

[neileg]

If you have a composite key that includes 5 columns in one table, how can it include only 2 in the other. If by that you mean that some of the fields are concatenatec, I'm afraid you'll have to change the design and separate the columns into their atomic values.

I agree. Access joins are specific matches, field to field. You can define the join on multiple fields, but they must match in each table.

You could concatenate all the fields into one field in each tables and join on that, which is the inverse of Pat's idea. Still sounds like your design needs to be revisited, though.

 

[Pat Hartman]

Please don't even think about concatenating 5 fields into one.