Can I link rows in different repeating tables?

Can I link rows in different repeating tables?

Post by mptraube » Wed, 27 Oct 2004 00:41:23


Hello,

I have several repeating tables showing different aspects of the same
patient visit occuring on a single day. Each table involved has two
columns in common: visit date and visit number. The other columns
contain the differing information. Currently, I insert rows on each
table "manually."

How can I:

a) Make it so that deploying a new row on the first table deploys new
correlating rows on all the others?

b) Have those rows deploy with the same date and visit number?

c) Create a print view that shows only the rows (across several
tables)pertaining to a certain date or visit number?

Thanks much!
 
 
 

Can I link rows in different repeating tables?

Post by Greg Colli » Wed, 27 Oct 2004 06:40:19

a/b)
Since you said you were inserting rows "manually", I'm assuming you meant via code. This being the case, then whatever code inserts the row on the first table can also insert rows on the other tables. That same code can also populate the date and visit number.

If you are not using code, you can use the OnAfterChange event handler to detect that this was a newly inserted row (i.e. the row will be blank), and then call code to cause the other tables to insert rows (look into the ExecuteAction() method).

c)
Create a secondary data source that keeps track of the active visit number and date. Then in the print view, filter the repeating tables based on the stored active values.


--
Greg Collins [InfoPath MVP]
Please visit: http://www.yqcomputer.com/




Hello,

I have several repeating tables showing different aspects of the same
patient visit occuring on a single day. Each table involved has two
columns in common: visit date and visit number. The other columns
contain the differing information. Currently, I insert rows on each
table "manually."

How can I:

a) Make it so that deploying a new row on the first table deploys new
correlating rows on all the others?

b) Have those rows deploy with the same date and visit number?

c) Create a print view that shows only the rows (across several
tables)pertaining to a certain date or visit number?

Thanks much!