Hello,

I have a (legacy) situation where I need to create a custom relation between a numeric field and an integer field. Is there any workaround for this in the designer (maybe using a type converter or a field expression)?

My current solution is to wrap the table in a view, and cast the key field. This works fine, but I am wondering if there are other alternatives.

Thanks,

Phil

(Edit: LLBL Version 2.0, SQL Server 2000)

I don't think this would be possible in the Designer. But you may try to create this relation manually in the code.

If you apply a typeconverter, you can indeed create a custom relation between the two. Also be sure that one of the two is the PK of the entity it's in.

Otis wrote:

If you apply a typeconverter, you can indeed create a custom relation between the two. Also be sure that one of the two is the PK of the entity it's in.

I tried the same thing but it is not working please see the thread. http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=21772

Let's continue this in your own thread.