foreign key relations connections

[imoree]

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

[comment]

Your question is not clear.

[imoree]

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]

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]

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]

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]

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