Hi,

anyone knows how to go about providing a sequent number for every portal row? I am rather new to FM7 and hope you can provide me the solution step by step. Thanks a lot in advance.

Hi voltrate,

Drop into Layout mode. Click into your portal. Type @@

@@ is the record number symbol. If you want a simple numbering of your portal items, this will do it. If you want something more, let us know and we'll help you with it.

LaRetta

Hi LaRetta,

Thanks for your prompt answer. I really appreciate it. I have another question which I need your expertise. I have a transactions table to receive multi payments for a Invoice table. In this transaction table, I have a field called "payment date" which is defaulted to the current system date using Get (currentdate)function. Question here...is there a way for user to overwrite the default date and input another date of their own?Currently its not allowing user to do so. Thanks.

Voltrate

newbie

is there a way for user to overwrite the default date and input another date of their own?

There sure is, Voltrate. Your PaymentDate field should be a standard date field. Set it to Auto-Enter calculation (through Options) with: Get(CurrentDate). Be sure the checkbox right under 'via Calculation' in the Auto-Enter tab is CLICKED.

It will insert the current date when a new Payment is added, but allow a User to type in a different date whenever they wish. If Users can't type into the field, I suspect two things: 1) It's currently a calculation instead of a standard field or 2) It is not allowing entry into field in Browse (check Field Behavior).

LaRetta

Dear LaRetta,

I got it! Cheers. Hope you don't mind helping me on another problem which I have been cracking my head on. My "invoice" table has a field which indicate the number of months which the "balance amount" will be repaid on a monthly basis. I also indicate a field with "payment start date" to show when the monthly transactions will kick start. Question here....can I automate in such a way that, every month when a transaction relating to a invoice occurs, the "due date" field in "transaction" table will indicate latest due month/date.

Here's an eg,

1) Payment start date (from Invoice table) = 05 Jan 2005

2) 1st New transactions(from transaction table), payment due date field = 05 Jan 2005.

3) 2nd New transactions, payment due date = 05 Feb 2005 and so on.

Thanks.

Are you assuming only one transaction per month? If so, you could try making Date_PaymentDue an auto-enter calculation of {UNTESTED}

Let ([

Dend = Date( Month(Invoices::Date_PaymentStart) + Invoices::Num_Months; Day(Invoices::Date_PaymentStart); Year(Invoices::Date_PaymentStart) );

D = Date( Month(Invoices::Date_PaymentStart) + Count(Transactions|InvoiceID::serial); Day(Invoices::Date_PaymentStart); Year(Invoices::Date_PaymentStart) )]

Case( D <= Dend; D )

)

where Transactions|InvoiceID is a self-relationship based on InvoiceID.

This may need to be tweaked depending on when InvoiceID is set.

Cheers. I will digest your suggested solution and see if it works. Thanks.