Thread: Foreign keys edit with pulldown?

It would be very nice if foreign key fields had a pulldown to select the 
value from existing values in the foreign table.  Are there any plans to 
add this functionality to pgAdminIII?

Scott

Scott Chapman wrote:
> It would be very nice if foreign key fields had a pulldown to select the 
> value from existing values in the foreign table.  Are there any plans to 
> add this functionality to pgAdminIII?

This sounds nice, I put it on the TODO list. Still, there are some 
caveats: The FK table may be too big to be usable in a combobox, we'd 
need some graceful limit here.

Regards,
Andreas

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: Monday, March 28, 2005 8:04 AM
> To: Scott Chapman
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Foreign keys edit with pulldown?
>
>
> Scott Chapman wrote:
> > It would be very nice if foreign key fields had a pulldown
> > to select the value from existing values in the foreign table.
> > Are there any plans to add this functionality to pgAdminIII?
>
> This sounds nice, I put it on the TODO list. Still, there are some
> caveats: The FK table may be too big to be usable in a combobox, we'd
> need some graceful limit here.

Well, if we're going down that road, why not also implement lookup
fields where it actually displays a relevant value from the foreign
table in the table view?

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129