Can not find related record.

[hwkranger]

I have a bunch of tables, and a bunch of relationships. This is the first problem I've encountered with my relationships, and it's a very odd one.

I have a ticketmaster table, and a table with ticket information.

the ticket master is 1:1 to the ticketinfo on the following fields: ID, MatchID, and OffsetID.

Now, the Ticket info has a field called RecoveryID, which has a number in it.

There is a Recovery Table that has a list of all the recovery types, with unique key RecoveryID.

These are related one to many.

Now, when I take a ticket, and put a number in it's "MatchID" field, then later go back and REMOVE the number from the match id field i get an error that says:

The Microsoft Jet Database engine can not find a record in the table 'tblTicketTypeRecovery' with key matching field(s)".

exactly like that.. odd. So, I removed relationships.. still get it.

anyone ever seen this before? I really need to be able to remove the matchid information if the users link the wrong tickets together.




Randall Vollen
National City Bank Corp.

Just because you have an answer - doesn't mean it's the best answer.

 

[hwkranger]

No need to solve this, I found the answer. Oddly enough, this is really really weird why it happened.

I found that my form had a subform that was based on a query that related tickets, it found tickets that were not recovered, and were offset to the main ticket. For some reason, changing the "matchid" that I had set up made an access error, even though this table wasn't included in the join.



Randall Vollen
National City Bank Corp.

Just because you have an answer - doesn't mean it's the best answer.