Hey duders, here's the situation...

I have a hardware database (Access). In this database I have many, tables, but we'll limit it to two for this discussion. Currently there aren't any relationships in the database.

I have a table "Servers" and a table "Cabinets". Mulitple servers can be located in one cabinet(Many-To-One Relationship).

I have two DataAdapters, entitled ServerAdapter and CabinetAdapter. Also, i Have one dataset, DsTest1.

I am displaying the data in seperate tabs, one for servers and another for cabinets. The data is already filling the appropriate text boxes, and changing from one peice of data to another has all been established.

Here's the prob...

When i browse thru the data on the server tab, that servers appropriate cabinet is shown in a text box. When i click the Cabinets tab, i want that cabinet's data displayed(the one from the textbox on the server tab).

I'm not familiar with db's so if anyone could help it would be great.