Pulling into a form from another form tool

[K Young]

I am looking at the possiblity of creating multiple forms with data that I
will use to basically assemble a master form of this collected data.

For instance I want to create a form that based either drop down lists or
other items that would allow me to select an option and then populate the
remaining fields in the master form. So I would create a form that would
have all of the information regarding a certain hotel chain. Then below that
I would have the State and then a City drop down. Once all three items have
been selected it would display whatever else relevant information in the
form. Is it possible to do this kind of a reference without any kind of
scripting? Essentially just pulling data from multiple forms to create one
form? Any help is greatly appreciated.

Thanks,

K. Young

 

[Marc Dimmick]

Yes, this can be done with the look up tables. I have it working within a
workspace and sort of working across workspaces.

Basically you are looking for a user to use a master form which its
dropdowns are populated from information supplied from other workspaces? If
that is the case then it can be done with the lookup's, I have not found
much in the way of documentation but you need to experiment with the lookups
with the dropdown field.

I have the Lookup's working in two ways one to populate a dropdown.

Selecting the lookup type: by key
using Tool: -This Tool-
View: 90. Drop-down List Item
Key Column: KeywordKey
Key Value: Work_32Stream
Lookup Column: KeywordValue
Return: All
Select: No Cache

Then remembering to Apply Property, because if you dont it wont be set.

This displays the KeyValue in the dropdown which is created from my
drop-down list item form

My next dropdown displays content based on the selection of the first
dropdown.

Its setting is
Selecting the lookup type: by Key
Using Tool: -this tool-
view : 91. Domain Expert (this form stores names
against work streams)
Key column: StreamName (this is the name of the workstream
selected in the first dropdown)
Key Value: Work_32Stream
Lookup Coloumn: DomainName (This is the name of the person)
Return : Unique
Select: No Cache

Apply Property


I have this working with a combination of dropdowns. One instance is you
select a company, from there a list of members of that company populate the
next dropdown and when the user select one of the people who is a member of
that company there phone and email address are displayed in two seperate
text boxes. It took a few days of mucking around but I finally got the who
thing working.

My next task is trying to get a phone list to beable to be used across
multiple forms in different workspaces. I have had limited success, but
still working at it.



--

Regards
Marc Dimmick

"The best way to predict the future is to create it" - Dr.Peter F. Drucker