RE: [AccessDevelopers] ACT! help

[Lava Boggavarapu]

Brian –   Here’s a quick solution.   The query SELECT Column1 FROM Table1   Returns the Column1 value and they would be labeled as Column1.   On the other hand SELECT Column1 AS MyColumn FROM Table1   Returns Column1 values, but they would be labeled as MyColumn.   Between the UI and table, insert a query that does this transformation. Now set the datasource for your UI as this new query instead of the original table.   HTH.   Lava   ------------------------------------------------ Lava Boggavarapu Lava Trading Inc. 95 Morton Street, 6th Floor New York, NY 10014 Tel 212.519.9371 Fax 212.519.9283 Mobile 732.668.2935 www.lavatrading.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of The only serious one! Sent: Monday, August 08, 2005 1:10 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] ACT! help   hello, I have an ACT database and i am trying to do wome data mapping.  My problem is the field name that is on the layout is different from the field name that comes over through ODBC.  Example: The layout is  the UI used by the end user. When i view this UI in Design view. it reveals the field names. Now when i extract the data through ODBC, the field names are totally diffrent. Is there a way to associate the field name on the layout with the name that is coming back throught odbc. This would be great help and save a tremendous amount of time trying to mapp this data. Thanks Brian Parker Programmer Analyst Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.