Hello people, I hope you can help me on this one.
I have two subforms, one with an already populated drop-down list of peoples names and in the second subform I have an numeric box.
Is there a way that I can have a certain name once selected from the drop-down list, to populate the numeric box with a set number, but doing so only allows a limit of what numbers (i.e. 0 to 10) to be inserted?
Essentially what I am getting at is when you select "John Doe" from the drop-down list he is only allowed to give up to a 10% discount, whereas "Sandra Smith" is allowed to give up a 15% discount.
So I think I need something that says if John Doe enters a value that is ≥ 11 then he can't but of course Sandra could.
Understand? I hope someone can help, thanks in advance.
if (RepName.rawValue == "Jane Doe"){
xfa.form.TableSubForm.Table.HeaderRow[0].Discount.rawValue = 10;
}
Where "RepName" is the name of the drop-down list and "Discount" is the cell within the first Header Row, within the Table, within it's own subform.
I tried to change "RepName" to "this", but still it doesn't seem to be working.
Thanks in advance.