imoree Posted September 6, 2011 Posted September 6, 2011 Ok, Question for a guru or regular person who understands this topic more than i. say for example: custID ---|| orders(cust_fk) simple equijoin - cust id = cust_fk , we have a relationship - when data is entered on customer context, HOwever , when in orders context, we have to allow Create a relation. Magic Keys, scripted key moving data back & forth can transfer keys, but how would i make a new relation without having that allow create in child table selected or is this just not possible? thanks
imoree Posted September 6, 2011 Author Posted September 6, 2011 2 images i have uploaded. - ALLOW is not selected - ALLOW is selected What i am saying is how do i create a relationship programmatically besides allowing creation or am i just being silly. I have done teh magic - key way as well as scripting keys from parent to child but in each option i have to have allow create selected. does that clear it up?
comment Posted September 6, 2011 Posted September 6, 2011 does that clear it up? I don't know what "create a relationship programmatically" means, nor am I familiar with "teh magic - key". If you mean how to create a new child record, without allowing the relationship to create new records, try something like: Set Variable [ $parentID ; Parent::ParentID ] Go to Layout [ Child ] New Record Set Field [ Child::ParentID ; $parentID ] ...
imoree Posted September 6, 2011 Author Posted September 6, 2011 That sounds like a great way to do it, but i was also asking if there were other ways than just that way. here is the link to a magic key relationship;; http://www.filemakerhacks.com/?p=2364 --
comment Posted September 6, 2011 Posted September 6, 2011 If you are not creating the record via a relationship, then it must be created as a new record in a layout of its own table.
imoree Posted September 6, 2011 Author Posted September 6, 2011 Comment, I see usually it is only you and Vaughn that answer the majority of questions asked in these forums, at least from what i see. I have a few working examples and i think i will be adding these to the articles and tips as i believe this is a very serious issue to grasp besides the Relationship graph, Table OCcurences, and Table OCcurence Groups. thanks . i really appreciate it. -i
Recommended Posts
This topic is 5082 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