Linking data together

[bob dolle]

Hello. I have been using MySQL for about 2 weeks now. I access and modify the database elements via jquery and php (it is an internal inventory system for my company accessed easily on a web browser).

We develop separate products that "mate" with each other. Example


Serial__Type__Mate
001______A____003_
002______A____004_
003______B____001_
004______B____002_

What I want to be able to do, because we have a lot of units, is to be able to change one cell and have it automatically change the other. So if I changed the Mate data for 001 to 004 I want 004's Mate to change to 001.

I am using one huge database for all our products. So unless someone know's the jquery way of doing this (should it exist) I am wondering what the SQL command would be to acheive it.

I can provide more info if necessary.

Thanks so much.