Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Data entry with foreign keys

lz7cjc's profile image lz7cjc posted 2 months ago in Feature discussion Permalink

Hi I am researching IDEs and was hoping you can help. I am specifically looking for a data entry tool that will display a searchable drop down with the labels from other tables, where the ids are foreign keys. So I can easily add e.g. products where the categories are stored in a different table, without my having to memorise or manually lookup the id for a particular category that the product is a part of.

Can you help me confirm if i can do this with HeidiSql? If there are any videos or images that demonstrate this, that would be fantastic

thanks for your help

ansgar's profile image ansgar posted 2 months ago Permalink

The drop downs in HeidiSQL's data grid show the local ids and foreign text column values, but are currently simple dropdowns without any search functionality. See issue #762 for a search tool request, which is probably what you need.

lz7cjc's profile image lz7cjc posted 2 months ago Permalink

ok thanks

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.