Jump to content

Multikey questions


This topic is 7604 days old. Please don't post here. Open a new topic instead.

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

Link to comment
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

Link to comment
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

Link to comment
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...

Link to comment
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.

Link to comment
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 !!!

Link to comment
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

Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

This topic is 7604 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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