SQL(Program) WINDOW- FK ASSISTANT

[DoDo]

As our database depends and useses foreign keys it is often difficult to remember all join attributes and if it consists of more than one attribute it is hard to write joins again and again. I think that I'm not alone in this so it would be nice to have a key or an icon which will do something like this:

--When we write in sql window:

Select (something from a), (something from b)
From tableA a, tableB b

-- and then we press a key or icon
PLD does:

Select (something from a), (something from b)
From tableA a, tableB b
Where b.fk1 = a.pk1
and b.fk2 = a.pk2
and b.fk3 = a.pk3
and b.fk4 = a.pk4

-- this is based on foreign key on table B referencing table A, if there is many FK, let it show "Pop Up" with all foreign keys and let me chose which ones to use
-- this can, also, be used in Program windows

Thanks in advance!

 

[ScottMattes]

I would like this. It is already 'there', but under the Query Builder, so it shouldn't be too hard to add this.

I'd also like to be able to force QB to show the FK dialog, like just now when I tried a simple two table query and invoked QB I had to drop one of the tables and re-add it in order to use the FK dialog

 

[DoDo]

Yes, I know about QB but it is too "slow" to write sql in QB! I agree it shouldn't be too hard to add this, so I asked for this!

 

[Marco Kalter]

I have added this to the list of enhancement requests.