# Connected record selection view **URL:** \ **Category:** Get Answers\ **Created:** [August 4, 2022, 6:04pm UTC](https://forums.knack.com/t/connected-record-selection-view/12864 "2022-08-04T18:04:47Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Jeffrey1](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@Jeffrey1](https://forums.knack.com/u/Jeffrey1)\ **Post date:** [August 4, 2022, 6:04pm UTC](https://forums.knack.com/t/connected-record-selection-view/12864/1 "2022-08-04T18:04:47Z")
I have connected tables together correctly, but when inputting a new record, need to select the record in the child field to be associated. The drop down for this shows only data from the first field in the connected table. I assume this is the key field, but somewhat irrelevant. In order to select the correct record, I need to be able to show 1 or more fields of my choice from the child table. Usually this gets done in a query or something, but not sure how to do it here. thx J ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [August 4, 2022, 6:30pm UTC](https://forums.knack.com/t/connected-record-selection-view/12864/2 "2022-08-04T18:30:57Z")
Not sure I understand your use case. Not sure why you need to select an option from the child table when adding a parent record. This would normally be done with record rules when adding the parent record. If you’d like to connect to show me your particular scenario let me know. ---
**Author:** ![Jeffrey1](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@Jeffrey1](https://forums.knack.com/u/Jeffrey1)\ **Post date:** [August 4, 2022, 6:45pm UTC](https://forums.knack.com/t/connected-record-selection-view/12864/3 "2022-08-04T18:45:01Z")
Maybe I am using parent/child incorrectly. It isn’t really important. Please disregard that part. I am creating a record and want to link it to records from 2 other tables. I have 2 connected fields with drop downs to let me select a record from each of those other tables. When I press the drop down, it shows me the data inside 1 and only 1 of the fields in each of those tables. That is not enough for me to make an informed decision as to which record to connect to. I would like to be able to select multiple fields in each table to be displayed when I press the drop down so I can select correctly. Perhaps this is clearer. thx ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [August 4, 2022, 7:43pm UTC](https://forums.knack.com/t/connected-record-selection-view/12864/4 "2022-08-04T19:43:44Z")
That makes more sense 😊 Add a Text Formula field to your child object(s) and concatenate the various fields. Then set this Text Formula field as the Display Field. This may help: > **[How to Show Multiple Fields in Your Connection Drop-Down](https://learn.knack.com/article/f9o3u8gm7o-how-to-show-multiple-fields-in-your-connection-drop-down)** > > Scenario. You need more information (or multiple fields) included in your connection field drop-down. Requirements. If this your first time creating an app, you'll need to know some basics about addi… ---
**Author:** ![Meagan](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@Meagan](https://forums.knack.com/u/Meagan)\ **Post date:** [May 30, 2024, 9:51pm UTC](https://forums.knack.com/t/connected-record-selection-view/12864/5 "2024-05-30T21:51:23Z")
Hi @Les - thanks for the quick reply. That is not quite what I am looking for I don’t think. If I have a connection that has a lot of data, how do I select which data I want to be pulled for the connection?