still not working!

[wideboyrob]

ok,

so i changed the fields in tblpreferences to number format, and added a pref.ID field which is autonumber format.
then when i try and drag sportID from tblSport to tblPreferences and make it en force ref, integrity and cascade update, it says
"relationship must be on the same number of fields with the same data types".

Plus the link between volunteer ID is still only one-to-one in that case!

sorry, need more help! thanx for the quick reply though!

rob

 

[wideboyrob]

apologies

sorry, should have posted a reply, not a new thread!

please see topic named "table relationship problem" for the previous posts for this problem!

rob