InfoPath Dev

Hi all,

Brand new here and fairly new to Infopath. I am looking for an example of how to populate a repeating table with data from 2 tables from a secondary data source. One has general information about an item and the other has line item details for the item so it is a one to many relationship between the tables. The data needs to be filtered on the username of the currently logged in user. I would also like to be able to hide and show the repeating table so it doesn't take up a lot of room on the form but the user can view it if they choose. The table will contain history information and the user may or may not want to see it.

Code examples would be great.

Thanks in advance for any help you can provide.

Oh yea. I also need to be able to filter on date and only show entries for the last 6 months. I am assuming it must use something like dateadd("m", -6) or something but can't find any references.

thanks,

Rhonda

Hi RB and welcome to our forum,
There are tons of examples. Try searching the forum and looking at the HowTos. Greg has several that talk to this scenario.