Jump to content
Sign in to follow this  
OnziTam

how can it be achieved in FM

Recommended Posts

i attached an excel file as an example of what i am trying to achieve with FM.

I need a form with two linked fields when i assign value regardless in which one the linked field has to change.

Any suggestions will be appreciated

Book1.zip

Edited by Guest

Share this post


Link to post
Share on other sites

One way to achieve this effect in version 3 (version 3??!!) would be to have two relationships to the Clients table - one based on Name, the other on Country. Each selection field would lookup its value from the opposite relationship.

Share this post


Link to post
Share on other sites

comment,

do you mean self-joining the name and country fields? i tried this and I just got more confused.

pls explain further

Share this post


Link to post
Share on other sites

It could be self-joining, or it could be from another table. I cannot say based on the information you have provided (none, really).

Share this post


Link to post
Share on other sites

Just out of curiosity I tried to make a table where two fields were each lookups of the other. It doesn't really work how I would expect. If the record is empty, then the lookup will proceed as expected regardless of which field you populate first. But when you try to change the value of either field you cannot because the lookup is triggered and you can't even clear the values.

The file I attached is from v8, but the concept should operate similarly in older versions.

lookup.fp7.zip

Share this post


Link to post
Share on other sites

OnziTam: you're not really developing in FMP 3 are you?

Share this post


Link to post
Share on other sites

Yes, you are right - it won't work that way. I tested this in version 4, and Filemaker won't even accept the definition of the second lookup. However, I am not going to agonize over this, because the more I think of the request, the less sense it makes to me. For this to work as shown (in any method), both Name and Country would have to be unique.

The "correct" way would be to choose from the related records SerialID's - which could be shown with either names or countries. Then both fields could lookup from a single relationship - or they could be eliminated altogether, and replaced by the related fields.

Share this post


Link to post
Share on other sites

Good question. They say v3 in their profile, and server 5 in the original posts?

Share this post


Link to post
Share on other sites

Hi all

I didn't pay attention to what version I selected.

I am testing on 8.5

Thanks for all responds anyway

Edited by Guest
Removed the shouting

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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