# Display the desired field **URL:** \ **Category:** How do I?\ **Created:** [July 6, 2023, 4:50pm UTC](https://community.weweb.io/t/display-the-desired-field/3406 "2023-07-06T16:50:14Z")\ **Posts on this page:** 11\ **Page:** 2
**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\ **Post date:** [July 17, 2023, 4:15pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/22 "2023-07-17T16:15:32Z")
You should check the settings of the Region collection and make sure that you include the ‘id#primary’ field ---
**Author:** ![icos](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/icos/32/4625_2.png) [@icos](https://community.weweb.io/u/icos)\ **Post date:** [July 17, 2023, 4:37pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/23 "2023-07-17T16:37:27Z")
I don’t know why, but ‘id#primary’ was off. Thanks for not dropping it).👏 It remains to be solved why the tables cannot be linked, but that’s another story and a question for Supabase.) 😓 ---
**Author:** ![Sebastian1](https://avatars.discourse-cdn.com/v4/letter/s/f19dbf/32.png) [@Sebastian1](https://community.weweb.io/u/Sebastian1)\ **Post date:** [April 10, 2024, 11:56am UTC](https://community.weweb.io/t/display-the-desired-field/3406/24 "2024-04-10T11:56:11Z")
@luka Hi Luka, I am having the same issue, but everything seems to be set up correctly. I have a product DB & a subcategory DB linked related with a “subcat\_id”, but the lookup does not return anything and also has an error for the first parameter. ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/54fdc6a5f0ec64b0cb5e56ec5e84f8afcbe73b3d.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/4/42974fa0ab37d362c35003e4a0213daaaeb3339b.png) I know these databases are linked correctly because it works in a Bubble app that uses the same database via an API. Any ideas? ---
**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\ **Post date:** [April 10, 2024, 12:35pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/25 "2024-04-10T12:35:02Z")
You are missing subcat\_id key in your lookup formula, it should be: ```auto lookup(item.data.subcat_id, subcategories.data, "subcat_id") ``` then you do ```auto getKeyValue( your whole lookup, "subcategory_name") ``` ---
**Author:** ![Sebastian1](https://avatars.discourse-cdn.com/v4/letter/s/f19dbf/32.png) [@Sebastian1](https://community.weweb.io/u/Sebastian1)\ **Post date:** [April 10, 2024, 1:00pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/26 "2024-04-10T13:00:19Z")
Hi Luka. I still get the same error. Does it make a difference if the id is an int8 and not a text string? ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/589cef49696975a252449b842ffab1a5166135a2.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/56ff76addaeceb7d16ae2c87520da525ff81c53a.png) ---
**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\ **Post date:** [April 10, 2024, 1:24pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/27 "2024-04-10T13:24:14Z")
What is the value of Item.data.subcat\_id when you have just it in the Formula input? ---
**Author:** ![Sebastian1](https://avatars.discourse-cdn.com/v4/letter/s/f19dbf/32.png) [@Sebastian1](https://community.weweb.io/u/Sebastian1)\ **Post date:** [April 10, 2024, 1:27pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/28 "2024-04-10T13:27:15Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/f/f1ad1352fd94be7b93f899ca6eef48db0ec4622d.png) ---
**Author:** ![luka](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/luka/32/1571_2.png) [@luka](https://community.weweb.io/u/luka)\ **Post date:** [April 10, 2024, 1:38pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/29 "2024-04-10T13:38:38Z")
Can you send me your editor link in private message if the data is not sensitive? I would like to take a look what’s going on here ---
**Author:** ![Sebastian1](https://avatars.discourse-cdn.com/v4/letter/s/f19dbf/32.png) [@Sebastian1](https://community.weweb.io/u/Sebastian1)\ **Post date:** [April 10, 2024, 1:45pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/30 "2024-04-10T13:45:27Z")
Thank you , sent ---
**Author:** ![dhew](https://avatars.discourse-cdn.com/v4/letter/d/b4bc9f/32.png) [@dhew](https://community.weweb.io/u/dhew)\ **Post date:** [May 2, 2025, 3:37pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/31 "2025-05-02T15:37:35Z")
This reply is very useful in understanding the core methods of accessing data in WeWeb. I vote a version of it should get added to the docs (maybe [here](https://docs.weweb.io/data/intro-to-collections.html)) as 1) it should inform how people build and 2) it succinctly introduces several building blocks that will be needed later (db views, local v remote data, realtime, filtering data, lookups, scaling, etc.), providing basic direction for users to research further. I only found this thread because it was suggested while I was writing a post on advanced collection field configuration! ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [May 2, 2025, 5:02pm UTC](https://community.weweb.io/t/display-the-desired-field/3406/32 "2025-05-02T17:02:48Z")
Thanks so much for taking the time to share this with us Daniel, really appreciate it and have passed it on to Matthew who’s handling all things user docs at the moment 🙂 [Previous page](https://community.weweb.io/t/display-the-desired-field/3406.md?page=1)