Hi all!

I'm getting an error which I can't figure out why...thus it's hard to debug ;^). I've used two SQL commands to create two views. I'm using the second one as a source for a report. I thought all was fine, but when I try to use the second view, rvmajorap2, I'm getting the following message:

"Base table fields have been changed and no longer match view fields. View field properties cannot be set (Error 1542)"

I don't recall any changes to the base table, so I'm a bit stumped. I checked the structure of the tables and things look compatible.

Any ideas??

Below is the SQL commands I'm using to create the two views.

*!* Create Major App report view #2 (get maucode name)

CREATE SQL VIEW rvmajorap2 AS SELECT *, ;
allcodes.dispval AS usedby;
FROM rvmajorap1 ;
LEFT JOIN allcodes ON rvmajorap1.maucode = allcodes.codeno ;
ORDER BY sysname

*!* Create Major App report view #1 (get matcode name)

CREATE SQL VIEW rvmajorap1 AS SELECT *, ;
allcodes.dispval AS support;
FROM majorapp ;
LEFT JOIN allcodes ON majorapp.matcode = allcodes.codeno ;
WHERE majorapp.acode = ?caid

Many thanks as always!

Mandy