hello i want add category in the order details table

[Hassan_Tanna]

i have products table  the category row i want add category in order details table how i can do that !

i want when i make a order first choose the category then the products 

[bonameblisto]

Excuse me. Im read's your question 20-times, but dnt understand what you want

[Joseph_Seddik]

I know his app. 

[Hassan_Tanna]

I didn’t explain  good but anyway thank you for reading my post and trying to help me 🙏

[Joseph_Seddik · Accepted solution]

1. Add a "Category" column to your Order Details table.
   
   
2. In the Order Details View, reorder your columns so that the user first selects the Category.
   
   
3. Do not show the Product column, unless a category is selected. In the "Show?" field, enter the following expression:
   
   ISNOTBLANK([Category])
   
   
4. The Suggested values and Valid if fields of the Product column should have the following expression:
   
   SELECT(Products[Product ID], [Category] = [_ThisRow].[Category])
   
   

It is better that you have a table for Categories and change the type "Category" columns in the Order Details and Products tables from Text to Ref pointing to the Categories table. In this case, the expression in point no. 4 above should be:

[Category].[Related Products]

[Hassan_Tanna]

 زمان الراجل الفوق بيقول هو الجدع دا بيقول ايه ،انا مش فاهم انا كاتب ايه بردو هههههه 😂انت الوحيد ال بتفهمني يا جو 🙏 
As usual come in the right time with solution , thank you jo

[Joseph_Seddik]

🤣 المصريين سرهم باتع برضه 😂

[Hassan_Tanna]

فعلا بالظبط 😂 حبيبي يا جو 😍