Select item from Lookup Table

[johnpinter]

I have a form that requires the user to fill in a code. The code is a non
descript code that means something to our accounting department. I have a
secondary database set up with 2 fields - the code and a description of the
code.

What I would like is to have a text box (within a repeating table) along
with a hyperlink or button next to it that opens up another view with a list
of all the codes and descriptions on this second view. The user then looks
up the description, selects one of those codes, the view switches back to the
original view and the text box gets filled in with the non descript code.

I can put a button that can switch views once pressed but prefer a hyperlink
due to aesthetics. I have tried a scrolling region with a repeating table as
in:
http://blogs.msdn.com/infopath/archive/2004/04/01/106039.aspx but can not
get any more than the first line of the database in the table.

Can anyone help with the following:
1. hyperlink to switch views
2. instructions on how to link the table in the scrolling region to my
database and make it display all codes instead of just the first
3. functionality to be able to select ONE of the codes, switch views to the
original and fill in text box on original view.

Thank you in advance

 

[S.Y.M. Wong-A-Ton]

1. You can use a button control and change its Borders and Shading properties
so that it looks like a hyperlink. You cannot use a hyperlink control, since
you won't be able to use rules on it to switch views.
3. If your text box is within a repeating table on the first view, it will
be impossible to set its value from the second view without using code. So if
you do not want to write code you'll need to rethink the design of your form.