Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Combine Universes or... 1

Status
Not open for further replies.

Kirkebbs

Technical User
Mar 28, 2002
10
US
How do a create a relationship (similar to the way MSAccess)between different data providers. Both data providers have
at least one identical field, thus it could be the index, so how can I get the result to display the results.

example...

Data provider1

Machine Name Program
Tool A PRG1
Tool b PRG2
tool c PRG1
tool d PRG1


Data provider2

Program Level
PRG1 Lvl1
PRG2 Lvl2
PRG3 Lvl3

Result I'd like to see

Machine Name Program
Tool A Lvl1
Tool b Lvl2
tool c Lvl1
tool d Lvl1

Thanks,
Kirk
 
Another easy one.

In the data viewer, link the Program objects. Then create a detail object out of level that is simply defined as &quot;=<Level>&quot;. Associate the new detail object with <Program>.

Create a new block and put what you want in it.

Steve Krandel
BASE Consulting Group
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top