Hello!

We have aquired a Filemaker database (ver 7, windows) and want to make a
small improvment.

We have a field called [lastnamne child], as we enter that namne we want
it to also automaticly copy itself to [lastnamne parent]as it usually is
the same. Idealy it would copy it self letter by letter but it's not
critical.

Some time we would import namnes from an excel file and it should do the
same then.

Also it happens that parents have a different lastname so it has to
accept  manual entries as well and keep those.

We have tried to make a link and a simple script but we could not get it
to work.

This is our first contact with filemaker and I'm sure it's doable. I
just don't know how.

Thank you for your time.

/Jonas P�rtma

You have a choice.

1. Manually: write a script which copies [lastname child] and pastes it 
into [lastname parent] at your discretion. Place a button on the layout 
which invokes the script when clicked.

2. Automatically: write the same script as above, but trigger it 
automatically upon change to [lastname child]. FileMaker does not do this 
by itself: there are a couple of free plugins that will provide the 
capability.

EventScript from http://www.softs4humans
zippScript from http://homepage.mac.com/jkornhaus/

The importing will work slightly differently:

A separate script could do the importing, then loop through the new 
records to copy and paste.

When you say the parents' name is "usually" the same (that's how it is in 
my home, funny how that works), you raise an issue about automatically 
copying, especially in an import situation. Does the Excel file contain 
the parents' name? You may have to include a test to see if the field is 
already populated before you paste something into it.

Matt

Jonas P�rtma wrote:

>Hello!
>
>We have aquired a Filemaker database (ver 7, windows) and want to make a
>small improvment.
>
>We have a field called [lastnamne child], as we enter that namne we want
>it to also automaticly copy itself to [lastnamne parent]as it usually is
>the same. Idealy it would copy it self letter by letter but it's not
>critical.
>
>Some time we would import namnes from an excel file and it should do the
>same then.
>
>Also it happens that parents have a different lastname so it has to
>accept  manual entries as well and keep those.
>
>We have tried to make a link and a simple script but we could not get it
>to work.
>
>This is our first contact with filemaker and I'm sure it's doable. I
>just don't know how.
>
>Thank you for your time.
>
>/Jonas P�rtma

You could make the parent last name auto 
enter a calculated value.When you do the 
import make sure to update auto enter 
operations.
If auto enter  is not flexible enough 
for your solution I have had good luck 
with zipp script that Matt Will recommended.
BD

Jonas P�rtma wrote:
> Hello!
> 
> We have aquired a Filemaker database (ver 7, windows) and want to make a
> small improvment.
> 
> We have a field called [lastnamne child], as we enter that namne we want
> it to also automaticly copy itself to [lastnamne parent]as it usually is
> the same. Idealy it would copy it self letter by letter but it's not
> critical.
> 
> Some time we would import namnes from an excel file and it should do the
> same then.
> 
> Also it happens that parents have a different lastname so it has to
> accept  manual entries as well and keep those.
> 
> We have tried to make a link and a simple script but we could not get it
> to work.
> 
> This is our first contact with filemaker and I'm sure it's doable. I
> just don't know how.
> 
> Thank you for your time.
> 
> /Jonas P�rtma

The first thing I'll do is to learn how to read. I have downloaded the
plugins and vill try them out.

Thank you for your help and beeing so kind about my reading abilties.

I consider this problem solved, all that is left is for us to decide
which solution to pick.

/Jonas P�rtma

BD wrote:
> You could make the parent last name auto enter a calculated value.When 
> you do the import make sure to update auto enter operations.
> If auto enter  is not flexible enough for your solution I have had good 
> luck with zipp script that Matt Will recommended.
> BD
> 
> Jonas P�rtma wrote:
> 
>> Hello!
>>
>> We have aquired a Filemaker database (ver 7, windows) and want to make a
>> small improvment.
>>
>> We have a field called [lastnamne child], as we enter that namne we want
>> it to also automaticly copy itself to [lastnamne parent]as it usually is
>> the same. Idealy it would copy it self letter by letter but it's not
>> critical.
>>
>> Some time we would import namnes from an excel file and it should do the
>> same then.
>>
>> Also it happens that parents have a different lastname so it has to
>> accept  manual entries as well and keep those.
>>
>> We have tried to make a link and a simple script but we could not get it
>> to work.
>>
>> This is our first contact with filemaker and I'm sure it's doable. I
>> just don't know how.
>>
>> Thank you for your time.
>>
>> /Jonas P�rtma

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com