Get range of related records in portal

[Kip]

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!

[-Queue-]

Yes. Create a multi-criteria relationship.

CurrentTable::dateFrom <= OtherTable::date AND

CurrentTable::dateUntil >= OtherTable::date

Base your portal on this relationship.

[Kip]

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

[Benjamin Baptista]

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

[Benjamin Baptista]

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

[aaa]

Look at Queue suggesttion and add here Agent=A

CurrentTable::dateFrom <= OtherTable::date AND

CurrentTable::dateUntil >= OtherTable::date And

CurrentTable::Agent = OtherTable::Agent

[Benjamin Baptista]

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

[aaa]

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

[Benjamin Baptista]

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

Invoice.zip

[aaa]

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

[Benjamin Baptista]

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

[Benjamin Baptista]

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