Hi,

I will try to explain this as best I can.

I am working with InfoPath 2003 sp1 and publishing these forms to sps
2003.

I have SQL database tables used to describe the
companies>department>system.

database table structure:
TABLES  company     co_dept     dept     dept_sys_xref    sys_name
COLUMN1  co_id       co_id     dept_id    dept_id          sys_id
COLUMN2 co_name     dept_id    dept_name  sys_id           sys_name

The structure of the tables needs to as is for the most part. There are
7 companies, 50 or so departments, and more systems than I can count
(with my shoes off).
I need to be able to choose a company and have it limit the number of
departments and that in turn limit the number of systems, I ma using
drop down list boxes.
I have been creating the form in InfoPath and when it comes to these
co/dept/sys I use a data connection to supply the data. The form won't
change much but the information in the SQL database for co/dept/sys
will. I got this to work once but I have no idea how and now I can't
get it back on this new form. I need help
please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Nicholas E. C. Monsour
IS/Technical Writer I
Liberty Healthcare Group
(772)398-5800 Ext. 23915
nicholasm@libertymedical.com