fmscoops

I'm using values from an External Data source to supply the web address for the webviewer. The field is called linkurl. Each customer has 2 links (primary and secondary). Now essentially the webviewer is doing what its suppose to do. I specify that field ->(bandwidth::linkurl) under the webviewer setup. So its showing one of the graphs. How would I be able to setup 2 webviewers showing the separate links? It'd be easy enough to do if 1 field was called linkurl1 and the other linkurl2, but its not setup this way.

Thanks for the reply David. I ended up using the Substitute calculation to make this work.

Our company uses something called MRTG, which displays graphs of our customers bandwidth usage. Now I am getting the link from an External Data source(mysql) table in a field called "linkurl". So as our employees page through our customers, they can go to a tab called MRTG which displays the graph using the webviewer. My problem is Each of our customers have 2 graphs assigned to them (in other words there are 2 related records for "linkurl" per customer and the webviewer is only displaying 1 of them. How can I show both related records in separate webviewers? If I just simply add 2 viewers it just displays the 1st record twice (or displays the same graph twice) Any help would be appreciated. Thanks

Here's what I would like to do: I have created a simple form to fill out whenever we receive new shipments for our customers. Once all the information gets filled out, I want to click a button that sends 1 email to all of the techs for that particular customer. Current setup: I have a shipments table that pulls data from 2 other tables(external source:mysql) called techs and clients. The first field on the "shipments" table is called customer. Its a drop down menu that auto populates values from the "clients" table. Now the "techs" table has a field called "email" which contains all of the email addresses for each of the techs for all of our customers. Now technically I have it working. When you click the button to send the results it opens up the email client and depending on the customer that is chosen it is correctly filling out the To: field (based on the relationship between the two). The problem is its only filling out the To: field with one email address. Each of our customers can have anywhere between 1-15 techs (email addresses). I would like to cc: all of the other techs(email addresses)automatically. Is there a way to do this?