Unable to link subform with Memo field?

[RoyKMathur]

I have a form/subform that I want to link together using a memo column, yet when I try Access tells me that the column datatypes are incompatible. I've even tried making both the form's and subform's recordsource be the same table. Any idea how I can do this?

 

[KenHigg]

I'm at a loss to come up with a scenario where one would need to link on a memo field... (or did I mis-read this?)...

 

[RoyKMathur]

I have DB2 Explain results that I'm displaying in an MS Access Form (and subforms) so I can view all the necessary info that I need to determine if the access path is acceptable or not. If I need to manually change the stats and re-run the Explains then it's possible that the QueryNo could change, so the only columns that I can use to determine whether it's the same query is the Collection Id, the Program Name and the SQL. The SQL is a Memo field, because it often exceed 255 bytes. When I review an Explain I keep my comments in a separate table; thus the need to join a Memo field.

 

[KenHigg]

Can you do something like a sql alias fld to link with?

 

[RoyKMathur]

I don't understand your suggestion. Perhaps there's more to Aliases than I know. Access is inhibiting me from comparing Memo columns, how would renaming a column get the Link to work?

 

[KenHigg]

I don't understand your suggestion. Perhaps there's more to Aliases than I know. Access is inhibiting me from comparing Memo columns, how would renaming a column get the Link to work?

Hum... I was just trying to come up with a way for you to create a new col (or field) where the value it stored was somehow derived from the sql statement which would make it an alias...

 

[RoyKMathur]

Since it appears that a VBA String can hold more than 255 bytes, I assuming that a possible solution is to handle the "join" using VBA code instead of the Form's Parent/Child Link "wizard" or an SQL (which doesn't allow it either). I was hoping there was a simpler solution.