Allright I'm Confused

[dynamictiger]

I have two tables set up something like:

tblMsg
ChemMsgID
Msg

tblParameter
ParamID
other stuff
ChemMsgID

In the table tblMsg I have been adding and deleting messages so I now have ChemMsgID like:
1, 8, 14,15,16 etc

But when I access ChemMsgID from tblParameter I am getting Id numbers of:
1,2,5,8,11,12,14,15 etc

I do not understand why deleted messages ID are still present in the parameters table nor do I know where to start to look for why.

 

[Transcend]

Do you have a relationship set up between the two tables? And if so did you select cascade delete on the relationship?
If you don't have a relationship set up on your tables then this will have happened, as access didn't know that teh two fields were to be related.

Transcend