Hello all,

I'm having a problem getting my portal to give the results I want.

It's a fairly simple structure. Table 1=Sales people; table 2=orders. I have a portal on "sales people" layout listing orders. No problem. What I would like to be able to do is refine it more to show only orders occuring through a range of dates. Thanks in advance for the help.

Add two date fields to your SalesPeople table (make them global if you want the range to apply to all records in the table), dateBeg and dateEnd. Then add a relationship (or modify your existing one, if it will not break any other processes) based on

SalesPeople::ID = Orders::PersonID AND

SalesPeople::dateBeg <= Orders::DateOrder AND

SalesPepole::dateEnd >= Orders::DateOrder

Base your portal on this relationship and enter the desired dates into dateBeg and dateEnd.