Home Good News Good Workshops Good Answers Good Content Contact About
Welcome to Good Training Sign in | Become a member - FREE!
Search
 
Good Training » GoodTraining.com Forums » The SalesLogix User Group » Re: Table Association

Table Association

Last post 06-23-2009, 1:11 PM by Dale Richter. 4 replies.
Sort Posts:

  •  06-23-2009, 9:00 AM 1882

    Table Association

    Is there a way to change a table association without deleting the table?  We associated a custom table to an out of box table and created all the fields.  We applied the changes and then a day later realized that the association was wrong.  We would rather not have to delete the table and recreate it since we have many fields in the table.  Any help would be greatly appreciated.  We are using 7.5.1 with SQL server 2008.

  •  06-23-2009, 9:38 AM 1883 in reply to 1882

    Re: Table Association

    Hi,

    I dont think this is possible, if it is it will be very risky - I would suggest you just drop the table and re-add it.

    Regards, Adam Travers

  •  06-23-2009, 10:11 AM 1884 in reply to 1882

    Re: Table Association

    I ran this past on of my programmers and this is the response that I received.

    Well I have never tried but it should be possible. SLX does not keep any relationships at the database level but rather only within the table, the sectabledefs, resynctabledefs, and joindata tables. As long as all of these get updated correctly you should be able to do so.

    I hope this helps

     

    Dale Richter
    Customer FX

  •  06-23-2009, 11:40 AM 1885 in reply to 1884

    Re: Table Association

    That is what I thought, but when I did look into the tables you mentioneda nd made changes, nothing happened.

    Thanks for the advise 

  •  06-23-2009, 1:11 PM 1886 in reply to 1882

    Re: Table Association

    You might want to post this on www.slxdeveloper.com site. They would be a bit more technical.

     

    Dale
View as RSS news feed in XML