Newbies jbruett Posted September 12, 2007 Newbies Share Posted September 12, 2007 Hey everyone, I have a lot of background with MSSQL and I am missing something that should be fairly basic with regards to table relationships. Using the below picture as reference is there no way to do the following? FEE::LoanOfficer_Branch = fee_emp_vl_LoanOfficer::Job Title OR FEE::BranchMananger = fee_emp_vl_LoanOfficer::Job Title AND Branch = Branch Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 12, 2007 Share Posted September 12, 2007 You're not missing anything, it isn't there! You need to do it like this: http://www.fmforums.com/forum/showtopic.php?tid/187182/post/252366/#252366 --sd Link to comment Share on other sites More sharing options...
Newbies jbruett Posted September 12, 2007 Author Newbies Share Posted September 12, 2007 (edited) Soren, Although I think what you sent me works, I am totally new with filemaker and don't understand some of the advanced query/database definition techniques that you are using...can you give me a bit more dumbed down version? Also I see that both the examples that you give in your link return into portals, I need the list to show up in a dropdown...I think that this is as easy as assigning a different field type. Edited September 12, 2007 by Guest Link to comment Share on other sites More sharing options...
David Jondreau Posted September 12, 2007 Share Posted September 12, 2007 Filemaker doesn't have an "OR" function for relationships. The way to do it is field level. Create a calculated field: ManagerOfficer = Fee::LoanOfficer_Branch & :paragraph: & Fee::BranchManager Then your relationship will be: ManagerOfficer = fee_emp_vl_LoanOfficer::Job Title AND Branch = Branch Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 12, 2007 Share Posted September 12, 2007 Portal or drop down, it does largely depend on how live the stuff is you wish to show in the dropdown, only stored fields can be displayed over a dynamic valuelist, so if you ave some sort of aggregate functins working with your data - are you bound to a portalfull of clickables. Otherwise is it smooth sailing, design yourself a dynamic valuelist with the relations I made in my first template. But it occures to me that what you wish to optain might be something like this: http://www.fmforums.com/forum/attachment.php?attid/3285/ --sd Link to comment Share on other sites More sharing options...
Newbies jbruett Posted September 12, 2007 Author Newbies Share Posted September 12, 2007 David, thanks, that solution worked...I can't believe that there isn't an OR feature in the relationship management. Soren, thank you also for your input. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 12, 2007 Share Posted September 12, 2007 I can't believe that there isn't an OR feature in the relationship management Well it arrived pretty late in the course of event's ....earlier on were we used to permutations over Davids appoach, more or less everything you have in the present relations def. dialog could be done via concatenated combinations of keys. The most famous is probably Edoshins SmartRanges: http://www.onegasoft.com/tools/smartranges/index.shtml Simply because we can exploit the unique feature calc'fields actually is compared to other RDBRS's... could we make all kinds of relational links via hashing algorithms. Beyond that should someone accustomed to the math of sets, be no stranger to DeMorgans Law! --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6205 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