jefjar
asked on
How do I setup a Repeating table with a repeating section with a number list?
I am new to Infopath and am attempting to set up a One on One form where employees can enter in information that is relevant to task and projects that they are working on. I first created an Access Database where I want the data to be pushed from Infopath. I then connected the database to the fields that I want on the form. In the section titled Current/New Task Assignments I have 5 fields:
Field 1: Auto assigned task number
Field 2: Date picker for the date the task was assigned
Field 3: Date picker for the date the task is due
Field 4: Project Update
Field 5: Drop down list for Task status.
These fields are all in a repeating table.
I want Field 4 to be a repeating section with a number list so that the data entered in are kept in sequence and then as additional updates are made to the task the list starts from the number 1.
I've tried making this field a rich text box, repeating section and a number list but I keep getting the error:
"A repeating section must be bound to a field or group that repeats" but I can't make this field repeat. Or when I try to insert the numbered list control I get the message " A numbered list control must be bound to a repeating field with a text or rich text data type."
What am I missing here?
Field 1: Auto assigned task number
Field 2: Date picker for the date the task was assigned
Field 3: Date picker for the date the task is due
Field 4: Project Update
Field 5: Drop down list for Task status.
These fields are all in a repeating table.
I want Field 4 to be a repeating section with a number list so that the data entered in are kept in sequence and then as additional updates are made to the task the list starts from the number 1.
I've tried making this field a rich text box, repeating section and a number list but I keep getting the error:
"A repeating section must be bound to a field or group that repeats" but I can't make this field repeat. Or when I try to insert the numbered list control I get the message " A numbered list control must be bound to a repeating field with a text or rich text data type."
What am I missing here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If I understand you correctly I have to set up second table and make that the primary and then a second key in the parent, main, table. This is done in Infopath correct or the database?