I have two date entry fields in one file:

-from: 01-01-2005

-till: 11-05-2005

In the other file I have all kinds of records with different dates.

Would it be possible using a portal to find the related records that match the dates in the date range entered?

Kip!

Yes. Create a multi-criteria relationship.

CurrentTable::dateFrom <= OtherTable::date AND

CurrentTable::dateUntil >= OtherTable::date

Base your portal on this relationship.

Just what I needed. Didnt expect it to be that simple! Thanks! This explains the "newbie" title i have been given...

Hi Que...

I have same problem with Klip, i have payment.fp7 file and invoice.fp7

What I want to do is using invoice.fp7 as a list of payment regarding agent wich is field in payment.fp7, I have create a portal but the portal show me all date of payment that agent payed.

What I want is having list of payment of agent with spesifik date exmple : 6/1/05 until 6/10/05 with agent A and also I want to make this record with spesifik number, is there is a way to do that ?

About table I was confuse is that table mean different file or same file ?

Thank for your kind attention

Ben

Hi Que...

I have same problem with Klip, i have payment.fp7 file and invoice.fp7

What I want to do is using invoice.fp7 as a list of payment regarding agent wich is field in payment.fp7, I have create a portal but the portal show me all date of payment that agent payed.

What I want is having list of payment of agent with spesifik date exmple : 6/1/05 until 6/10/05 with agent A and also I want to make this record with spesifik number, is there is a way to do that ?

About table I was confuse is that table mean different file or same file ?

Thank for your kind attention

Ben

Look at Queue suggesttion and add here Agent=A

CurrentTable::dateFrom <= OtherTable::date AND

CurrentTable::dateUntil >= OtherTable::date And

CurrentTable::Agent = OtherTable::Agent

I had follow your suggestion but now my portal show me nothing......

Am I doing something wrong ? but if I delete relation of date from and date until it's show me again di list..

Cheers

Ben

Attach a little part of your two files please.May be you have not records in this date range for choosing A.

Here is my file..... agent use admin as password

Invoice.zip

DateFrom and DateUntil must be Global fields if you want to use them in relation for date range.I chaged them to glibal.Look attachment.

DDD.zip

Thank's A it's run as I want it.....

As my previous attachment, how can I browse only the agent in range of date.

For example in range of date 06/01/2005 until 06/10/2005 only the agent wich have balance payment show in the browse mode.

Thank for your kind and help

Cheers

Ben

Hi A,

you may pass my post #164935, I had find the solution for this posting I realy surprise this think is so simple in FM.

What I do is made one field that equel with No. Bill and made "find" script which is No. Bill set > 1 so I will find List of Agent that had balance payment in range of date "datefrom" to "Untildate"

Thank for your again

Cheers

Ben