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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Global Join

Chokri
Posts: 62

Global Join Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jul 07 4:35 AM

In Global Join Manager we already have a global join in our database with the following format:

Parent table = userinfo
Parent field = userid
Child Table = *
Child Field = modifyuser
Type = inner
Cascade = replace
Visibility = allow

I wish to create another join which is similar to the above but with a different join field. However I can not enter an * in the child table (when editing the existing join the parent and child tables are greyed out and in the child table is displaying 'Any Table'). Can anyone tell me how to achieve the above without creating a local join.

Thanks.

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Global Join Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jul 07 8:48 AM

I tried opening one of those fancy "*" joins, and table listed is "Any Table." I tried to add a new table and look through the list of tables, but that really neat "Any Table" was nowhere to be found. Your best bet is to do this manually with an insert statement - but beware, the "Any Table" thing seems like a powerful function, and it might cause weirdness in your system.

I know the joins table is a table you'll want to create a record in, but I don't know about any other tables. I would check in the joins table to see how SalesLogix records the "Any Table" or "*" in it, and then I would also run the profiler at the same time you create a test join to see what else you might need to do to create a join manually, and then build the statement yourself.

If this seems at all iffy to you, contact a business partner and they should be able to assist you with this properly.

[Reply][Quote]

Chokri
Posts: 62

Re: Global Join Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jul 07 8:23 AM

Will try this - thanks

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/9/2025 6:14:51 AM