chris.paschen
Chris Paschen
I've tried to figure out exactly how to use the 'Single yes where' but can't figure it out.
The tip says:
Specific use-case:
I have master (one) table of: ked_books_books
With a primary field of: id
I have a child(many) repeating table of: ked_books_books_39_repeat
With a field that connects the two tables of: parent_id
I would like to use the 'single yes where' to force that just 1 entry in the ked_books_books_39_repeat with the ID matching the current ked_books_books___id has a 'yes' value (i.e. only 1 'yes' per book).
I've tried all of the following syntax, but nothing seems to do what I am trying to achieve:
The tip says:
table.field = '{table___field_raw}'
Specific use-case:
I have master (one) table of: ked_books_books
With a primary field of: id
I have a child(many) repeating table of: ked_books_books_39_repeat
With a field that connects the two tables of: parent_id
I would like to use the 'single yes where' to force that just 1 entry in the ked_books_books_39_repeat with the ID matching the current ked_books_books___id has a 'yes' value (i.e. only 1 'yes' per book).
I've tried all of the following syntax, but nothing seems to do what I am trying to achieve:
- ked_books_books_39_repeat.parent_id = '{ked_books_books___id_raw}'
- '{ked_books_books_39_repeat___parent_id_raw}' = '{ked_books_books___id_raw}';