Jump to content
Sign in to follow this  
Anh_Tran

Multikey questions

Recommended Posts

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 par.gif 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 smile.gif ...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 par.gif aaa par.gif bbb

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

Thanks

Anh Tran

Share this post


Link to post
Share on other sites

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. crazy.gif

Share this post


Link to post
Share on other sites

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

Alternate:

MiddleWords(Namefield,1,1) & " par.gif &

MiddleWords(Namefield,2,1) & " par.gif &

....

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. grin.gif

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Hey Christian,

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

I've just experienced it.. wink.gif 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 !!!

Share this post


Link to post
Share on other sites

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" grin.gif

Share this post


Link to post
Share on other sites

... 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.

Share this post


Link to post
Share on other sites

Hello Christian and Ugo ...

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

Sorry to get back you guys late since I leave work soon as usual smile.gif ...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 par.gif MOMI par.gif 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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Quito 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.