Thanks for that Gary. The field in one of my tables is specified as a 'Number' long integer, and the field in the other table it is specified as an 'Autonumber' long integer. Is this what is causing problems? If so what should I be setting them to?
...and what is b/b? You'll have to excuse me...
Hi all,
Can anyone help please? I am trying to create a relationship between two fields of two tables, and enforce referential integrity (I am trying to get ticks in all three check boxes, including cascading updates and cascading deletes in the edit relationships window). The problem is it...