Hi everyone,
I’m trying to fetch the product description in NocoBase by linking it with the product code, but I couldn’t find a “linked record” field or a similar option to achieve this. Am I missing something, or is there another way to reference related records to retrieve data like the description?
Any guidance would be appreciated!
Thanks in advance.
Please provide the detailed table structure.
Judging from your screenshot, you want to associate the Product table in table A and use a sub-table component to display the Description information from the Product table in the Description field of table A? Then, in the sub-table shown in your screenshot, configure a default value on the Description field to make it equal to the Description field in table A.
Thanks for your reply!
Yes, exactly. I have a Product table with fields like Product Name and Product Description.
In the Order form, I have general order details like Customer, Date, PO Number, etc., and I’ve added an Order Details sub-table linked to the Product table — so users can add multiple products to each order.
What I’m trying to achieve is:
When a user selects a product in the sub-table, I want the Description field in that same row to be automatically filled based on the Product Description from the linked Product record.
Let me know if there’s a recommended way to do this in the sub-table
Thanks again!
