SQL Data Connection to multiple tables

[Will]

I am creating a form with data connections to multiple tables. I am using a
form using a SQL data connection.

My setup is a form that will pass item data to a SQL database.

There is a table called Item which has main item data.

There is also a table called ItemCategory that contains the item number and
category id. There can be multiple instances of an item with different
category ids.

There is also a table called Category that contains the categoryid,
categoryname, and categorydescription.

I have a main data source called item and it contains the item table,
itemcategory table, and category table. I have also create another data
source that contains just the category table.

There is a repeating section that is linked to the category table with a
drop down box control that lists all available categories. The drop down box
displays the name but passes the id as the data.

What I need it to do is when I query and item number it lists all the info
for that item. It does this now.

I also need to be able to click the add new category button in the repeating
section and select a new category to add to the item.

Is there a way I can have this setup so when I select a category it will
display the name of the category,and pass that data via my web service to the
itemcategorytable?

I am using InfoPath 2007 and it is not a browser enable form.