Hi everybody,

I need some help with this:

Making a new record in an articles table I would like after typing the article's code in a field, the next field named "article's description" to be autoentered with the content of the first existing record having the same code.

In fact I made this functioning using scripts. So far it only looks clumsy, but I am afraid, when the database grows it will also work like that.

Thanks in advance.

nena

Выше гор могут быть только горы

на которых еще не бывал.

я болгар, энтусиаст

Hi Nena

because the autoenter that you require is only triggered after the first entry it is what is known as an 'event based' action.

This is not catered for natively by FMP but there are plug-ins that will do what you want.

A free plugin called 'Eventscript' can be found at

http://www.softs4humans.com/FMPro_Plugins.html and that will do what you want

HTH

Phil

Thanks,Phil,

In my table now it is working with this script. I was just wondering if I can simplify the file and omit any extensions. Not a problem actually.

Thank you.

Nena

Выше гор могут быть только горы

на которых еще не бывал.

Why would you need a script for this (not to mention a plugin)? If you define a self-join relationship based on the category field, you can auto-enter the value from the first record in the selected category.

AE.fp7.zip

Of Course.

Forgive me nena, my brain got stuck on the words autoentered and didn't think further than autoentry on record creation.

My apologies once again for missing the obvious

Phil

Hi, veteran,

I feel a sort of confused. My problem has been so easy.

Your AE.zip was one to one what I needed.

It's amazing in just two hours to have the helpfull advice.

Thank you all.

nena

Выше гор могут быть только горы

на которых еще не бывал.