slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - SalesLogix Web Client (Pre-7.2)
Forum to discuss using & developing the legacy SalesLogix Web Client (For versions 7.0 and earlier). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Client (Pre-7.2) | New Thread

View: Search:

Author

Thread: Display data from multiple tables in a query (7.01)

Dave McGill
Posts: 47

Display data from multiple tables in a query (7.01) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 May 08 2:09 PM

Does anybody know of a way to show data from multiple tables in a query? We have added an ExtendedAddress table to store extra information that is related to the address (ie. checkboxes for Small Packages and Large Packages). I would like to edit the ALTADD query to include our custom checkboxes, but the aliases I created don't show in the list of columns that can be added to the query.

If I create HTML aliases for the fields, they show in the list of columns to add to the query, but the query only returns 1 address instead of returning all of the addresses for the contact. It seems that the query can only show columns that exist in the main table specified for the query.

I know I can do away with the ExtendedAddress table and add the fields to the Address table, but any other ideas would be greatly appreciated.

Thanks,
Dave

[Reply][Quote]

Jeff Ballard
Posts: 326

Re: Display data from multiple tables in a query (7.01) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 May 08 6:27 PM

Dave,

Create new aliases for the fields from the other table (ExtendedAddress) that you want but create them by starting at the main table of the query (Address) and joining to your destination table.

You can also use your HTML field - I've used them many times to allow the user to select which rows to delete.

Jeff

[Reply][Quote]

Dave McGill
Posts: 47

Re: Display data from multiple tables in a query (7.01) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Jun 08 8:29 AM

I had CONTACT as the main table, but choosing ADDRESS as the main table resolved my problem. Thanks!

Dave

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 8:10:34 PM