cascading drop-down list populated by database

[Jeff]

I am wondering if the following is possible and if so I
could use alittle help. I have a form that is a front-end
for an access database. On the form there are two drop-
down boxes at the top of the form. The first one is
called employee name, this is a drop down box and I have
manually entered the employee names in the form and it
will not look up Employee names from the database. Once
the user selects their name from the first drop down I
want a second Drop down box, which contains client names,
to be populated from the database to display only those
clients that belong to that Employee. (So an employee
will pick their name from the first list and then the
second list will be populated with a list of only their
client's names) Then they can choose which client they
want to query detail about. So in the end they will see
all transations in a repeating table for that client they
have selected from the second drop down list. I am
assuming it is a filter I need to setup but I am at a
lose of where to even start. Thanks for any help.-Jeff

 

[Jerry Thomas [MSFT]]

One of our MVPs has put together several examples of this type linking.
This would be a good place to start.
http://www.infopathdev.com/examples/

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

 

[Scott]

Jerry,
Is this the "Populating Fields After Selection, v1.0" example?

How does 1 obtain a password in order to extract the files?

Thanks,
Scott

One of our MVPs has put together several examples of this type linking.
This would be a good place to start.
http://www.infopathdev.com/examples/

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

I am wondering if the following is possible and if so I
could use alittle help. I have a form that is a front-end
for an access database. On the form there are two drop-
down boxes at the top of the form. The first one is
called employee name, this is a drop down box and I have
manually entered the employee names in the form and it
will not look up Employee names from the database. Once
the user selects their name from the first drop down I
want a second Drop down box, which contains client names,
to be populated from the database to display only those
clients that belong to that Employee. (So an employee
will pick their name from the first list and then the
second list will be populated with a list of only their
client's names) Then they can choose which client they
want to query detail about. So in the end they will see
all transations in a repeating table for that client they
have selected from the second drop down list. I am
assuming it is a filter I need to setup but I am at a
lose of where to even start. Thanks for any help.-Jeff

 

[Jerry Thomas [MSFT]]

There were several that appeared to be on the right track.
As far as the pw, I didn't realize there was one.
Ask about that through one of their forums.

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Jerry,
Is this the "Populating Fields After Selection, v1.0" example?

How does 1 obtain a password in order to extract the files?

Thanks,
Scott

One of our MVPs has put together several examples of this type linking.
This would be a good place to start.
http://www.infopathdev.com/examples/

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

I am wondering if the following is possible and if so I
could use alittle help. I have a form that is a front-end
for an access database. On the form there are two drop-
down boxes at the top of the form. The first one is
called employee name, this is a drop down box and I have
manually entered the employee names in the form and it
will not look up Employee names from the database. Once
the user selects their name from the first drop down I
want a second Drop down box, which contains client names,
to be populated from the database to display only those
clients that belong to that Employee. (So an employee
will pick their name from the first list and then the
second list will be populated with a list of only their
client's names) Then they can choose which client they
want to query detail about. So in the end they will see
all transations in a repeating table for that client they
have selected from the second drop down list. I am
assuming it is a filter I need to setup but I am at a
lose of where to even start. Thanks for any help.-Jeff