2 field primary key in many to many

[jon_sg]

Can anyone help.

I have posted the relationships out of a db that I am creating. I have just about finished and there is one particular field that is causing me a headache.

The project is to create a financial tracking system.

Everything works but I have fudged the fldAmountpaid and as 97% of the time this field is not needed I would like to get it out of tblTurned (M2M join table) and into a 1 to 1 relationship in the tblAmpaid with tblTurned. The form and VB rework that this would require is pretty minimal.

tblTurned has to have a 2 field Pk (so I don't want to use autonum) as the data validation rules are based on this.

I am not sure about how to set this relationship or if it is possible.

Thanks in advance for your help.

Jon

 

[jon_sg]

I've Sorted it

Before anyone replies.

I just had to specify both fileds in the join window simple really.

Must have had more beers than I thought last night

Happy Xmas folks