How to Create Lookup Field in Sequel Pro?

122 views Asked by At

I have a table with a primary key lbxProgID.

The FK is lbxClientID that references a clients table.

zoom in of fields in question:

zoom in of fields in question

Currently when I want to add an entry to this table, I need to know the actual integer ID of the client so I can add the data.

In order to make data entry faster, is there a way to setup Sequel Pro so that when I click on the "lbxClientID" field it will show a drop-down list of the client fields in the clients table (i.e. clients.ID, clients.First, clients.Last). And when I click it enters the ID?

Thanks!

1

There are 1 answers

3
DW33 On

I spoke with Sequel Pro support and they said it's not possible yet.