Auto find missing data

[lastpass]

Hi! and Happy new year!

I have a simple question but I didn't find my answer here. (and anywhere).

My records have adress fields: Name,Company, City, Adress, Zip code, Telephon No., Fax no. etc.

If I create a new record I start fill the form with Company field, so there is a drop-down list and I can choose a company that already in my database.

I want to FM autmatically fill other fields from an exsisting record wich contians the chosen company.

How can I solve this?

[efen]

Like the attached?

main.zip

[lastpass]

Thanks but I have a little different problem (attached)

I have 1 table with data records and I want to fill it manual if adress doesn't exist. If company already exsist other fields should be automatically filled by FM or script or something.

There will be different informations in the data field so the adress can be equal but DATA field not.

Thank you in advance!

Adress1.zip

[efen]

If you just want to repeat all the information in all fields except the data field why not just have a script to duplicate the chosen record and set the DATA field to blank [""] ?

You could create a cartesian join relation (the X join in the relationship graph) of the table with itself (by the ID field - if this is unique)so that you could have a portal showing all the companies from which to choose your record to duplicate.

Any new companies could then be added by creating a new record.

You will have lots of almost duplicated records using this method so it might be an idea to consider amending the structure of your file so that each company is a unique record and the DATA field records are related in another table.

Edited January 7, 2010 by Guest
added text

[lastpass]

I tried like you describe but it doesn't works (I am a beginner in FM).

I attach my practice. Please fix my mistakes.

Auto look up doesn't works too. I never use this function maybe I dont understand how it works.

Thanks.

Adress1.zip

[efen]

Your file modified with cartesian join and script for related data records

Address1_mod.zip

[BostonBuckeye]

In you scripts -

1. You start by finding that previosu record

2. Now create a new record

exit

the user now enters his data

use a trigger for some complete or exit action to start a new scripts that searches for blank fields and "fills" them from your previosu records - there is a script for filling in from a previous record

[lastpass]

Finally I have successfully made the right solution with efen first file. [color:red]Thank you very much! And thanks for the quick answers and files.

Maybe it's not the best idea but works like that I want to.

main.zip

[efen]

What exactly does your script achieve?

[lastpass]

If you write a new company in 'data' table

srcipt will copy all data from actual records to 'adress' table.(and duplicate the data amount?). Script activated by exit from last field.

Next time I can choose this company from the value list.

[efen]

OK. Can't check this -- only have version 8.5, no script triggers