sync two tables on databound controls

[Michael]

Hello,
I have a windows app I'm writing in C#. It is connected to a MS Access
database. The Database has two tables, User table and UserRights table.
They are related on UserID. Now in the app, I have a form with a listbox
that is bound to the User table. I also have several textboxes. I want some
of the textboxes to be bound to the User table and some to the UserRights
table. Also, I want when the user clicks on the UserName in the listbox, to
show the appropriete information in the textboxes. I can get this to work
when I only have the User table hooked up. But I do not know how to hook up
the UserRights table so the data shows the right record. Also, I want to be
able to update the records in both tables, when the user hits the save
button. How can I do this?

Thank you very much for your help.

Let me know if there is any questions.