How to pull only certain records

[sammi]

I have developed an infopath forms which is connected to a MS access db. I
have two forms: form 1 is an data entry form. form 2 is review/approval
form. On 2nd form, I have a pull down - which a user selects their
department. Is it possible to limit the data to only records which has not
been approved?

Should I be using rules? Query w/ rule?

Thanks in advance.

 

[S.Y.M. Wong-A-Ton]

If you've bound your form to the database, which it sounds like you have, and
you're using a repeating table/section to display data, you can create a
filter (in the Properties dialog box of repeating table/section, on the
Display tab there is a Filter Data button) to filter the records.

 

[sammi]

Thanks you very much. It worked.

I have another question. How do I show multiple records after filtering.
If I had 2-3 records? Is it possible to show it in same page?

 

[S.Y.M. Wong-A-Ton]

Your repeating table/section should show multiple records if the filter you
put on it is not restricting it to come up with only one record. So if you're
coming up with only one record, double-check that you've set the filter
appropriately to come up with multiple records.