Binding non repeating data to a repeating table??

A

Art

Same project as before:

I have a repeating table of items to order that is bound to a database.

Then I have a section named shipping information (ship to name, address, etc).

When an order is placed for multiple items (e.g., multiple rows inserted),
the shipping info binds to the first row only. In other words, in the
database, if they order pens and staples, the shipping info is with the pen
order but the staples record has nulls for the shipping information.

Is there a way to bind non-repeating data to a repeating table?
 
A

Art

I got it

For everyone's benefit, I set up separate text boxes for the fields and then
used those fields as default values for the repeating data.

I now have a form with 4 views, stores data in a SQL databse based on look
ups in a second table, emails results and even looks good

My thanks to S.Y.M. Wong-A-Ton for his patience and knowledge.
 
S

S.Y.M. Wong-A-Ton

Wow! I get credit without answering a question? :) Art, many people have
made the assumption that I'm male, but I'd like to reiterate that I'm very
much female. :)
 
A

Art

My apologies my lady :)


S.Y.M. Wong-A-Ton said:
Wow! I get credit without answering a question? :) Art, many people have
made the assumption that I'm male, but I'd like to reiterate that I'm very
much female. :)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Submit rows of a repeating table to a SharePoint list 1
How read fields in a Repeating Table within another Repeating Table 0
displaying items in a repeating table in Print View 0
InfoPath repeating table choice 0
Binding controls in a repeating table 0
Auto-populate repeating table 1
Supplying data to a textbox inside a repeating table 0
Programmatically populate repeating table 1

Top