I'll try to explain this as best as possible. I have two external content types. One is Projects and the other is tasks. Both are from SQL databases.
Now I've created both content types and need SP to work in such a way that when I select the Lookup to the external list and select a project name, when I then go to select the Task name it should pull only the tasks available in the project. Anyone done this before? Ie. One to Many Relationship.
Google'd and found this : LINK but It won't let me finish when setting this up. Thoughts?