filter help please.

N

Nick Monsour

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
[email protected]
 
Top