OnziTam Posted May 12, 2007 Share Posted May 12, 2007 (edited) 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 May 12, 2007 by Guest Link to comment Share on other sites More sharing options...
OnziTam Posted May 13, 2007 Author Share Posted May 13, 2007 here even a ms access example of what I am trying do in FM. pls note you need vba enabled. Auto-select.zip Link to comment Share on other sites More sharing options...
comment Posted May 13, 2007 Share Posted May 13, 2007 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. Link to comment Share on other sites More sharing options...
OnziTam Posted May 13, 2007 Author Share Posted May 13, 2007 comment, do you mean self-joining the name and country fields? i tried this and I just got more confused. pls explain further Link to comment Share on other sites More sharing options...
comment Posted May 13, 2007 Share Posted May 13, 2007 It could be self-joining, or it could be from another table. I cannot say based on the information you have provided (none, really). Link to comment Share on other sites More sharing options...
Reed Posted May 13, 2007 Share Posted May 13, 2007 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 Link to comment Share on other sites More sharing options...
Vaughan Posted May 13, 2007 Share Posted May 13, 2007 OnziTam: you're not really developing in FMP 3 are you? Link to comment Share on other sites More sharing options...
comment Posted May 14, 2007 Share Posted May 14, 2007 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. Link to comment Share on other sites More sharing options...
Lee Smith Posted May 14, 2007 Share Posted May 14, 2007 Good question. They say v3 in their profile, and server 5 in the original posts? Link to comment Share on other sites More sharing options...
OnziTam Posted May 15, 2007 Author Share Posted May 15, 2007 (edited) Hi all I didn't pay attention to what version I selected. I am testing on 8.5 Thanks for all responds anyway Edited May 15, 2007 by Guest Removed the shouting Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6191 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 accountSign in
Already have an account? Sign in here.
Sign In Now