Temporary relationship

[Waki]

Hi, i've this problem. I've made an invoice db, with automatic calculation of multi-payment (example, first part after 30 days, second after 60d, third after 90 days). The 3 part calculation is not a problem. What i can't do is a new table, with the list of all my payment, so for the invoice number x with 3 payment, i wanna 3 line(record) in this new table. How can i make an automatic record creation in this new table, when i set the number of payments in my invoice?

Thanks in advance

[Søren Dyhr]

How can i make an automatic record creation in this new table, when i set the number of payments in my invoice?

Well I wouldn't but instead make the invoice show up 3 times in a related table holding all dates as keyvalue - the way it could be accomplished is to exploit that a pilcrow-delimited keyfield makes the omission of a dedicated join table posible.

If you wish to make a found set of the days something needs to get paid, make a show all search in the invoice table, followed by a GTRR(FS) and only the records in the date table which correspond to a payment date belongs to this found set.

BTW could you instead of the pilcrodelimited make a 3 repetition repeating field containing:

Extend ( invoicedate ) + Get ( CalculationRepetitionNumber ) * 30

...giving the same result as key value!

--sd

[GC GYM]

What is a pilrow delimited field?

[mr_vodka]

Pilcrow is the paragraph symbol ( ¶ ).

So basically a Pilcrow delimited field would be a field with a value like this:

A ¶ B ¶ C¶.....

Which result in a key field would actually be typed in as

A

B

C

D