Hi All,

I've got a customer who decided to hack the CRM dbase (despite me
saying not to) and I'm trying to reverse the changes.

I'm trying to work out how he populated one field from another, in SQL,
by using an unsupported hack.

He changed it so that a field from the Productbase populates a field on
QuoteDetailbase.

I've been told that all he did was bring up the table design view of
quotedetailbase, select the field from the quotedetailbase table then
in the grid pane just found the column and selected the productbase as
the table.

Only thing is that it doesn't appear in the grid pane. Under the custom
field it just says Quotedetailbase!

I know this isn't a post call out, it was definatley done through SQL.

Anyone know of any other ways he could have achieved this? or any ideas
for a SQL query that will tell me everything about the field in
question and how it's linked?

Thanks

Tom

This is CRM 1.2 by the way

It's kinda hard to follow what you are saying was done. I would ask them
for an exact detailed description of what was done and what isn't working.
Depending on what data was changed, it could be OK, but if anything was
related to one of the GUIDs, then it could be causing a security corruption
issue.

--

Matt Parks
MVP - Microsoft CRM


"Bouffont" <bouffont@gmail.com> wrote in message
news:1138023464.909542.212330@z14g2000cwz.googlegr oups.com...
Hi All,

I've got a customer who decided to hack the CRM dbase (despite me
saying not to) and I'm trying to reverse the changes.

I'm trying to work out how he populated one field from another, in SQL,
by using an unsupported hack.

He changed it so that a field from the Productbase populates a field on
QuoteDetailbase.

I've been told that all he did was bring up the table design view of
quotedetailbase, select the field from the quotedetailbase table then
in the grid pane just found the column and selected the productbase as
the table.

Only thing is that it doesn't appear in the grid pane. Under the custom
field it just says Quotedetailbase!

I know this isn't a post call out, it was definatley done through SQL.

Anyone know of any other ways he could have achieved this? or any ideas
for a SQL query that will tell me everything about the field in
question and how it's linked?

Thanks

Tom

This is not an answer but a warning to use caution. The customer may have
done far more than they are saying and are hoping that you can magically fix
their mistakes. Just make sure their mistakes do not cost you in unbilled
consulting hours etc.


=======================
John O'Donnell
Microsoft CRM MVP
http://codegallery.gotdotnet.com/crm




"Bouffont" <bouffont@gmail.com> wrote in message
news:1138023464.909542.212330@z14g2000cwz.googlegr oups.com...

Matt and John,

Thanks for the replies - I actually had to back out of this one for
pretty much the reasons you'd said.

Thanks

Tom