How to pull only certain records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sammi - 02 Apr 2007 18:50 GMT

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.

Signature

Thanks,

Sammi

Reply to this Message

S.Y.M. Wong-A-Ton - 03 Apr 2007 09:06 GMT

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.
---
S.Y.M. Wong-A-Ton

> 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
[quoted text clipped - 5 lines]
>
> Thanks in advance.

Reply to this Message

sammi - 03 Apr 2007 13:32 GMT

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?

Signature

Thanks,

Sammi

> 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
[quoted text clipped - 12 lines]
> >
> > Thanks in advance.

Reply to this Message

S.Y.M. Wong-A-Ton - 04 Apr 2007 08:00 GMT

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.
---
S.Y.M. Wong-A-Ton

> Thanks you very much. It worked.
>
[quoted text clipped - 17 lines]
> > >
> > > Thanks in advance.

Reply to this Message