The reason for the error is because dbFront assumes that it needs to create a join on that field because its name matches an existing table field.
Because you changed the datatype the join will fail.
If you don't want to join on that field then just rename it in the view. I prefer to precede formatted fields by a "v" so that I can easily identify them. You can pick whatever standard works for you.
If you want to join on that field and format it then I would create two columns in that view for the one column.
- The original value with the original name and datatype for the join,
- The renamed version formatted and typed as you please.
That will separate out the formatted value and allow you to use it where needed.
