Problem: I have a repeating table where are fileds:
- Category (drop-down list box)
- Product Name:(drop-down list box) which has two rules 1 - for field Code, 2 - for field Price; to auto-fill
- Code (text box)
- Quantity (text box)
- Price (text box)
- Value (text box)
Source: Access (eventually - sharepoint)
I would like to field product showed only the names (the drop-down list) that overlap with the category. For example, When I select a category WRITING in the Product field, viewed only name attached to it like a pen, pencil, etc.
Thanks in advance for helping and prompt answers.