How can we help you today? How can we help you today?

Foreign Key Join Suggestions

Hi

Another bug ?

When I type "Inner Join On" , I get the Candidate list that shows my 3 (in this case) Foreign keys at the top and the Columns of both tables , after selecting the first one for the Join , the Candidate list now show only the Column List and not the previous list including the Foreign Key selections . Hence I have to manually enter the other 2 Foreign Keys.

This is obvioulsy different from 3.9

Also in 3.9 with multiple FK's there was a composite option as well with all 3 Join conditions with AND in between eg fk condition1 AND fkCondition2 AND fkCondition3

Is this still to come , it was one big labour saver

Mike
MikeONeill
0

Comments

1 comment

Sort by
  • Chris George
    Hi Mike,

    Thank you for taking the time to post this issue. Unfortunately multiple foreign keys didn't quite make it into the Early Access release. Rest assured that they will definitely be in the release candidate!

    This includes both the list of multiple keys, and the composite one.

    Sorry for any inconvenience this may cause in the meantime and I hope you are enjoying using Prompt 4!

    Regards

    Chris
    Test Engineer
    Red Gate Software Ltd
    Chris George
    0

Add comment

Please sign in to leave a comment.