0

I am creating a sign-up list for a company potluck, and I want to show the number of certain dish types that have already been signed up for. Details:

I have two lists: Potluck Signup List, and Dish Type Lookup List.

The Dish Type Lookup has 3 columns: Dish Type, Count of Dish Type, and Dish Type Total. There are 3 records in the list showing the available Dish Types (Main Dish, Side Dish, Dessert).

The Signup list has a Lookup to Dish Type Lookup populating a dropdown with the items from the Dish Type column of the Lookup List. In the Lookup list, the Count of Dish Type is a lookup back to the Signup list showing the Count of Related items. It shows how many items in the Signup List have each Dish Type selected (i.e 3 for Main Dish or 2 for Dessert).

Dish Type Total is just a Number field I'm using because Lookup fields can't be used for some things. I've got a workflow updating this value successfully.

I've created an InfoPath Form for the Signup List. What I'm having trouble with is that I want a label (Calculated Value field) to show the number of people who've already signed up to bring the type of dish chosen by the Form user. For example, say I am signing up to bring a Side Dish. I want to show on the Form that 2 other people have already signed up to bring Side Dishes.

I have two data connections in the InfoPath Form: Main (Signup List), and Secondary (Lookup List).

I added the Calculated Value field, and set it to retrieve the Dish Type Total from the Lookup List. By default, it will show only the first row's value, so I wanted to add a filter. My filter is:

Dish Type (Secondary) = Type of Dish (Main)

When I try to publish though, I get the error in the question title. The full error is:

Control binding is not supported: Binding a non-repeating control to a repeating field or group is not supported in SharePoint list forms. To fix this problem, remove the control or replace it with a repeating control, such as repeating section or table.

When I try to add a table and put the Calculated Value field into it and create the binding to Dish Type Total (Secondary), I get the following error:

A repeating table must be bound to a field or group that repeats. In addition, the field or group must contain other fields.

I feel like I'm going in circles now, and have been working on this for hours. Web searches have proven fruitless. How can I get the current value of Dish Type Total from the Lookup List to show in a field on my InfoPath Form based on the value of the Dish Type Dropdown?

Thank you in advance. If I can clarify anything, please let me know!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.