Hi, when testing my repeatable table I've encountered a problem thats very annoying.
This is the setup:
categorie | product | productnumber | price | amount | price total | orderstatus
DD | DD | TB | TB | TB | TB | CB
* DD = Drop down
* TB = Textbox
* CH = Checkbox
after you choose a categorie you select a product, when the product is selected the productnumber and price are automaticly inserted with rules i applied on the product DD
these rules are:
Productnumber: set value of a field (=productnumber TB) --> then I go and select the productnumber out of the sharePoint list (secondary source and apply a filter to that, with the value: product (SharePoint list) = product (DD)
Price: set value of a field (=price TB) --> then I go and select the price out of the sharePoint list (secondary source) and apply a filter to that,
with the value: product (SharePoint list) = product (DD)
now for the PROBLEM:
this works great but the flaw is, for example when i choose the first product in the list (after i choosed the categorie) when i insert another row, and choose for another product, like the second or third the price and productnummer still are the valeues of the first product in the list.
when i start from the last product in the DD the values do change when i go from last to first, but when going from first to last it only takes the first values of the DD item in the price and productnumber TB's
what am I forgetting to do? or what am I doing wrong?
thank you in advance!
greetings Kevin