Need repeating section, 3 fields submitted, 4th auto-filled and hi

[TimWaters]

I am writing a form for work and the relationship between the two tables is
one-to-many.
The big table has a customer_order number field. The small table has 4
fields with the customer_order field as the primary key, like I said, in a
one-to-many relationship. I need a repeating section that contains text boxes
for the other 3 fields in the small table and when that is submitted, I need
the customer_order.smalltable to be filled in with data from the displaying
customer_order.bigtable that the user used to query and submitted to the
database when the user submits the other 3 fields. I am just learning
InfoPath right now and am not sure how to accomplish this. It is a very
simple Access 2003 database and InfoPath 2003.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

You can use the Master/Detail control to work out One to Many relation ship
between tables. Bind your big table to Master and Small table to Detail
table. You can get the master table value into one of the fields in the
detail table also.

 

[TimWaters]

All I need is 3 fields from the bigtable to show up after the query, one of
them being cust_order which is in both tables. Then I need to submit
hist_date.smalltable, hist_entry.smalltable, and hist_init.smalltable to
smalltable. But I also need some way to submit cust_order.smalltable without
the user seeing it. From looking at is this morning, the master/detail wants
to include everything from the bigtable in a repeating section, which I don't
need. It is a simple form with 3 textboxes needing to be filled in after a
query and the value of one of them going to a field in smalltable. I don't
know why I'm having such a hard time implementing such a very simple thing.