Joint-forbindes mellem Memo, OLE, Hyperlink

Jeg tror ikke du kan gøre ret meget. Det er simpelthen egenskaberne i felttyperne der ikke passer sammen.

F.eks. et notatfelt (memo) kan ikke indekseres.

No you cant JOIN on a MEMO field, the data can be far too large.

It is possible (I think) to join on the first 256 characters but ther is a very good chance that they arent unique.

I think you should look at the design of your tables, haveing to JOIN on two MEMO fields means that the same data exists in two or more tables and this should be avoided.

Hvis nu man har et notatfelt udelukkende med tal, kan må så blot ændre det til tal-felt og på den måde løse en del af problemet?

what data do you have in your memo field?
If it is too large then youcant change it to a number fields, unless you make it smaller.

A memo field can contain 1000's of characters and there is no number field type which can be so large.

If the first table which contains th ememo field has an aoutonumber as the primary key then this would b eused in the related table as the foreign key and you woul djoin on these.


Example:

tbl1
ID (Autonumber primary key)
MyMemoField (Type Memo)


tbl2
ID (Autonumber primary key)
IDtbl1 Number (long) (Foreign key) relationship to tbl1

Hej Terry

Hvis du svarer, sender jeg dig point for denne. Tak.

:o)

thanks