Scripting question...

[DukeS]

Hi!

I have a problem with adding new records and data.

I have one table with records of dates (valid from and valid to) and prices.

Exmpl.: 1.1.2000 / 10.1.2000 / 100$

In other table I want to add record with current date and also the price for that date. I need something that will pull out the correct price for current date.

Should I write a script that goes in other layout and searches for date or is there a different way to accomplish this?

Thanks for any help

Dean

[transpower]

Try a calculation field rather than a script.

[-Queue-]

In your other table I would add an auto-entered creation date field (if you don't have one already). Then create a relationship to your price table using

CreationDate >= price::dateValidFrom

AND

CreationDate <= price::dateValidTo

Then you can use an auto-enter calculation of relationship::price.

[DukeS]

Yep, that's right!

Everything is working fine.

Thank you very much.