Feature Request: Form View >>> List Of Values On Foreing K

[darroyo]

Hello,

imagine two tables:

– users(userid, name)

– cars(carid, userid, model)

If I execute the following query:

select c.model, u.name from cars c left join users u on u.userid = c.userid

I obtain results like this:

MODEL NAME

Toyota David

Audi John

If I change to form view and want to modify the userid of the car… it would be possible a drop down of the users names? The feature would be to select a user name from a drop down and then save changes (updating the field userid of the table cars).

Thanks for your job.

Best regards,

David.

[peterlaursen]

Now: what if there are thousands or millions of rows? Do you think a dropdown is handy? Not to mention that it may take minutes to fetch all values from the server.

It should rather then be an implementation similar to the 'Foreign Key lookup' as introduced in 9.0. Have you seen that?

[darroyo]

'peterlaursen' wrote:

Now: what if there are thousands or millions of rows? Do you think a dropdown is handy? Not to mention that it may take minutes to fetch all values from the server.

It should rather then be an implementation similar to the 'Foreign Key lookup' as introduced in 9.0. Have you seen that?

You're right. I don't know about 'Foreign Key lookup'. I'm going to take a look 🙂

[Author]

Posts