# Implement Single-Select Option for HubDB's Foreign ID Column **URL:** \ **Category:** HubSpot Ideas\ **Tags:** design-manager\ **Created:** [April 30, 2024, 3:11pm UTC](https://community.hubspot.com/t/implement-single-select-option-for-hubdbs-foreign-id-column/106144 "2024-04-30T15:11:25Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![ndwilliams3](https://avatars.discourse-cdn.com/v4/letter/n/c4cdca/32.png) [@ndwilliams3](https://community.hubspot.com/u/ndwilliams3)\ **Post date:** [April 30, 2024, 3:11pm UTC](https://community.hubspot.com/t/implement-single-select-option-for-hubdbs-foreign-id-column/106144/1 "2024-04-30T15:11:25Z")
The Foreign ID column in HubDB currently supports selecting multiple rows from a table. However, there are frequent instances where only a single reference is required. Relying solely on training and field description notes to enforce a single selection is inadequate for ensuring consistent data. To address this, it is crucial to implement a single-select option for the Foreign ID column in HubDB. ---
**Author:** ![arinker](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/arinker/32/14511_2.png) [@arinker](https://community.hubspot.com/u/arinker)\ **Post date:** [October 21, 2024, 4:40am UTC](https://community.hubspot.com/t/implement-single-select-option-for-hubdbs-foreign-id-column/106144/2 "2024-10-21T04:40:57Z")
I fully support the suggestion to implement a single-select option for HubDB’s Foreign ID column. There are many cases where selecting only one reference is essential. **For example, in a custom event management system, each event should be linked to a single venue from a venue table. Similarly, in a job board setup, a job listing should be tied to only one department.** Relying on training or field descriptions to limit selections is not enough to ensure consistent data. A single-select option would make managing these scenarios much more efficient and reliable.