I appreciate your help. Maybe I don't fully understand the JOIN command. Though I do understand the other syntax.
My problem is not getting related data from the second table, it is exporting multiple columns that contain data from the SAME field in the second table.
For Tables A and B...
Yes, there is a common Contact ID.
My question is how to include data from the same field in the related table in multiple columns on the report. Related record with certain search parameters in col 1
Related record with different search parameters in col 2
etc...
Is it possible to write an SQL statement to export mutliple instances of History rocords with a single Contact record?
I want to select and export some fields of a contact1 record along with 4 columns from the conthist records containing the conthist.date of the most recent conthist.activity...
Is it possible to write an SQL statement to export mutliple instances of a related field in a single record?
For example, ContactsTable is related to ContactHistoryTable. I want to select the contact record and export 3 columns from the ContactHistory records containing the most recent...
I have a web page which dynamically creates PDFs. When the PDF is created, Acrobat launches in front of the browser window (using this code):
function Open_link_subwindow(Link_href)
{
var Link_subwindow = window.open('','linksubwindow','width=600, height=420, resizable, scrollbars, status...
I have a validation summary control that displays error messages for any required fields not filled out.
For my phone number field, I validate to make sure that the field is filled out, and then a second validation to see if it had been filled out with the correct number of digits.
If I don't...
How do I validate dynamically created fields? For example, I have a form with dynamically created drop-down lists like this (parts b and c):
<asp:DropDownList id="DOB1a" runat="server">
<asp:ListItem Value="">Month</asp:ListItem>
<asp:ListItem...
This is an easy one (but I don't know how to do it)
I have a search form -- there's a checkbox for "search all" and a textbox for "search by name".
I need the check in the "search all" checkbox to become un-checked when someone types something into the textbox.
I know my asp code should check...
Does anyone know why IE sometimes gives textboxes a yellow background?
I have several forms with uniform color settings for the text boxes. However, some (but not all) people get yellow instead of the color I've chosen on some of the boxes.
Has anyone else seen this?
Using CSS, I have set a certain color for active links. Is there a way to set the state of a link to active using the OnLoad function?
In other words, I have a left-frame navigation bar with a list of links. I want tht link to the homepage to be in the active state (with the proper color) as...
I have a page with left and right frames. The left frame contains links which are set to a different color when active. This works fine as long as the user uses my links to navigate -- clicking on a link causes the new link to be in the active state.
However, if the user hits the "back"...
I have a link that needs to do the following with one click:
1. open a page in my right frame, and find a named anchor.
2. run some javascript contained in the page.
Ive tried this:
<a href="javascript:parent.right.location='deadlines.html#sir';parent.right.openandclose(0)">
and this:
<a...
I dont think its the "0".
Here's a post I did this morning that might make more sense:
I need the following to happen with a single click:
1. navigate to new page (with named anchor)
2. run javascript.
here's what I have so far:
<a href="deadlines.html#slr" target="right"...
I was going to try that, but the function (it opens a collapsible menu) refers to the menu's layers, etc.
I can't put all of the code in the left frame, because I don't want the menu to display there.
What I need to do is have a single click load the page, find the right part of the menu and...
I need the following to happen with a single click:
1. navigate to new page (with named anchor)
2. run javascript.
here's what I have so far:
<a href="deadlines.html#slr" target="right" onClick="javascript:parent.right.openandclose(1)">
The problem (I think), is that the onClick event...
Actually, I'm trying to do this, but with no luck so far:
<a href="javascript:parent.right.location.href = 'file.htm;'; openandclose(0);"
I've also tried:
<A HREF="file.html" TARGET="right" onClick="javascript:parent.right.openandclose(0)">
This almost works, except the function...
In a frames page, I need to click on a link in the left frame, and run some script from another page in the right frame:
javascript:parent.right.openandclose(0)
This works, but only if the page containing the script is already open. I know I need to have the link open the page in the right...
I have an image that needs to change on mouseover. It also must execute a javascript when clicked on. I gan get one function or the other to work, but not both at the same time.
here's the code:
<div id="pullout1Sidebar"><p align="center"><a...
I have a menu bar that currently requires a mouse click to open the second-level pull-out menu. I have been asked to change it from opening after a "click" to opening on a mouseover.
I changed this:
<a href="javascript:pulloutStart(0)">whatever.jpeg</a>
<a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.