hi all,

I am new to multikey but I find that very helpful. I have 3 fields , field one is Name_One, field two is Name_two, field 3 is checking

Record one : Name_One , Name_Two

abc , abc abd,

so when I check name_one and name_two, they must be equal right? because name_one is in list of name_two ...am I correct?

One more small question ...if

field 1, field 2

record 1 : abc , abc

record 2: abc, aaa and so on ...bbb

how can i make the cal so that the result is : abc aaa bbb

I want it automatically not ....manually typing ...

Thanks

Anh Tran

a. Are you kidding ?

b. But what is that mess !!

c. Can you be "more" specific ?

so abc = Are you kidding ?But what is that mess!!Can you be "more" specific ?

Sorry. I've been reading at this for 10 minutes...

Terrible headache at the end.

Substitute(NameOne," "," ") --or ", ", if there are commas+blanks in between.

Alternate:

MiddleWords(Namefield,1,1) & " &

MiddleWords(Namefield,2,1) & " &

....

MiddleWords(Namefield,9999,1)

(this is best generated by a script, then pasted into define fields)

But still, I don't understand what you are going to check against what and why this is done. Maybe you better start to explain the initial problem in plain & simple English, not in FileMaker gibberish.

Hi both of you....

Excuse me to be such a pest, but I would love to understand what's Christian calculations are leading to here. As I didn't catched the question, I cannot understand answer.

But since it seems there is an answer, so I may need such a calculation in the future....

Thanks. And sincere apologizes to Anh for my first answer...

just edited my post. Unfortunately, this is the second post from Arggh_Tran today that I did not really understand. Just guessing and replying to the 3rd section of the question.

Hey Christian,

Have you ever experienced a REALLY hard good laugh in front of your computer screen.

I've just experienced it.. That was your second "good" post today. I just love German sense of humour.

I'm so sure Anh would now love being called Arrgh Tranh !!!

Poor Anh. He was probably just trying to sort out duplicates. But he made it really impossible to help him.

Strange country where people are named "abc, aaa and so on ...bbb"

Well,

Anyway, I agree with Arghh...

I am new to multikey but I find that very helpful.

... but not that helpful when it comes to checking for dups.

a self-join based on 1=1 probably is a lot easier.

btw, good paris police didn't come to get you because of your incomprehensible laugh burst a three am.

Hello Christian and Ugo ...

Two europeens against one Canadian??? ... I don't think I could win so I ...Arrggggg....

Sorry to get back you guys late since I leave work soon as usual ...I want to compare one field to other ...Let's try simple English or else I must try Germany or Fracais ...:

Field_One : data : MOMI

Field_Two : data : MO or MOMI or MOMP

I want to compare when people type in field_Two

1- MO ..it is good

2- MOMI ...it is good

3- MOMP ...that is not good

Sorry above message what I try to say is ...

Field_One : data : MOMI

Field_Two : data : MO MOMI MOMP then I compare field_one and field_two ....

I think I could find the solution ...Thanks two Europeens ...you guys are helping me alot ...

Thanks

Anh Tran