View Single Post
  #5 (permalink)  
Old February 2nd, 2010, 09:07 AM
leonardpogrady leonardpogrady is offline
Authorized User
 
Join Date: Jan 2010
Location: Whitsundays Australia
Posts: 36
Thanks: 1
Thanked 0 Times in 0 Posts
Default MS Access SQL Problem

Hi,

The below Server behaviors in DW are named Dynamic Text field

Code:
Server behaviors below in same order-
<%= Recordset1.Fields.Item("CompName").Value %>
<%= Recordset1.Fields.Item("CompABN_ACN").Value %>
<%= Recordset1.Fields.Item("CompTradAs").Value %>
<%=(Recordset1.Fields.Item("CompTrdAdL1").Value)%>
<%=(Recordset1.Fields.Item("CompTrdAdL2").Value)%>
<%=(Recordset1.Fields.Item("CompTrdAdL3").Value)%>
<%=(Recordset1.Fields.Item("CompTrdCrty").Value)%>
Is that what you ar looking for?

I noticed somthing, when I double click the Dynamic Text field Client Company Name in the Server Behaviors panel another dialog box opens with-

Set value to <%= Recordset1.Fields.Item("CompName").Value %>
at the bottem of the box from a list of Columns from the Company file, the id
Columns is also there but not selected. I do not see where the Id is selected anywere in the Dynamic Text field such as the ("CompName").Value

LEN
Reply With Quote