Hey guys, wonder if anyone could assist,.....

I was adding some fields with links in to AssetCenter. Added a couple but when I tried adding 'WarrantystartDate' I received an error,...

I then deleted this,... but now when I open portfolio it does let me in but I get the following message,

ODBC error: (microsoft) (odbc sql server driver) Invalid Column name 'Warrantystartdate; sqlstate: s002 (line2 of script 'irrelevant' of link computer (computer) in table 'Portfolio items (amPortfolio)
Parameter0='17976'

I looked on google for similar errors and one guy (who had the same error although not in AssetCenter) said the the problem was caused as it was trying to access a column which was not retrieved as part
of the query......

Although not being very clued up on sql wouldn't know how to reslove this?

I thought I had deleted the field and link?, does this look as though the link is still trying to look for the field in sql which is nolonger there?,

Anyone had a similar problem?

Thanks,