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...
 
Top