# Form \> "Single select" grab all column values from other table?
**URL:** https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903
**Category:** Form-View
**Created:** [October 21, 2023, 1:05am UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903 "2023-10-21T01:05:05Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Gio](https://community.nocodb.com/u/Gio)
#### Post date: [October 21, 2023, 1:05am UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/1 "2023-10-21T01:05:05Z")
I’m new and experimenting with nocodb - my goal is simple I would like to create a form, whose available “options” are pulled from an existing table.
Imagine that I have a CAR database with a column named “Car models”:
- Corolla
- Camry
- Odyssey
etc.
I wanted my form to dynamically change the available “Car Models” options for a given question in the form based on the table reference, is this possible? Thanks
---
### Author:  [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [October 21, 2023, 1:57am UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/2 "2023-10-21T01:57:53Z")
It is not possible for select fields type. Closest that I can find to your requirement is `Links` field type. [Links | NocoDB](https://docs.nocodb.com/fields/field-types/links-based/links)
Good thing with Links field type, you get to display more information about the `Car`, not just car name - when user is making that choice from the form.
---
### Author:  [@Gio](https://community.nocodb.com/u/Gio)
#### Post date: [October 21, 2023, 3:48pm UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/3 "2023-10-21T15:48:48Z")
> [@dstala](#):
>
> It is not possible for select fields type. Closest that I can find to your requirement is `Links` field type. [Links | NocoDB](https://docs.nocodb.com/fields/field-types/links-based/links)
thanks for the quick reply. I will give Links a try to see what the UI looks like but I have a feeling it isn’t what I am looking for.
The goal of the form is to provide web visitors with the ability to propose new table entries based on a well-defined set of available options in the form. For the car\_models example, think of it as a “Service request form” to schedule customers for service for their Camry vehicle for example (I wanted other fields to have either multi-select or single select options but all the available options displayed for these form elements already exist in some other table already, so referencing and using that data vs. having to keep maintainance on the form manually every time a new Car\_Model is created is what I was after)
---
### Author:  [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [October 21, 2023, 4:03pm UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/4 "2023-10-21T16:03:41Z")
Try Links. It will fit this requirement & is easy to maintain data segregated into two separate tables.
This is what it would look like when selecting a record & display on grid
---
### Author:  [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [October 21, 2023, 4:05pm UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/5 "2023-10-21T16:05:16Z")
I had tried a relation `Vehicle Type` has-many `Service Log`; this way, from service side it will be a belongs-to relation; and we show actual data for belongs to instead of rollup count as in the case for has-many and many-many relation.
Feel free to get back to us if you need more help
---
### Author:  [@Navi](https://community.nocodb.com/u/Navi)
#### Post date: [October 22, 2023, 2:01pm UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/6 "2023-10-22T14:01:36Z")
@Gio : thanks for bringing this up. I have [raised this as a feature request](https://github.com/nocodb/nocodb/issues/6775). This could be done via conditional form elements.
If there is a platform that solves this already for you - please let us know.
---
### Author:  [@Gio](https://community.nocodb.com/u/Gio)
#### Post date: [October 22, 2023, 7:15pm UTC](https://community.nocodb.com/t/form-single-select-grab-all-column-values-from-other-table/903/7 "2023-10-22T19:15:04Z")
> [@Navi](#):
>
> If there is a platform that solves this already for you - please let us know.
Thank you for raising a FR to investigate a solution in nocodb.
I’m getting test accounts in platforms similar to nocodb to see if there’s a readily available solution. I am very early in my research - I haven’t come across a “out of the box” solution to solve for this but I have come across Airtable’s solution here: [Cannot add Multi-select options to a form based on... - Airtable Community](https://community.airtable.com/t5/other-questions/cannot-add-multi-select-options-to-a-form-based-on-a-linked/td-p/126164)