creating layouts and records remotely

[staypuffinpc]

I can't figure out how to write this script. I'm kinda' new to FM so perhaps this is a bit beyond my scope, but I really would like to use it. It's kinda' involved. In plain english, this is what it does:

Part A. Is there some way to have a dialogue box appear upon activating a "new record" btn asking for a name and serial number?

Part B. After entering in a name and serial number, then hitting a "create" btn (or automatically), this should happen:

1. go to another database

2. go to layout "main" of that DB

3. copy the "main" layout

4. rename the "main copy" layout to whatever name was entered in the original DB name field.

5. Return to the main DB and show the information in the new Layout via a portal, allowing users to modify and add records.

Part C. I would also like to be able to do this:

1. the user enters in a number in DB 1.

2. that number is compared to the number of records in that layout of DB 2

3. if the number is greater in DB 1, take the difference and create that many new records in DB 2, numbering each of them in an n+1 sequence

4. The portal would then allow the user to modify the different parts of each individual record of layout x

Thanks ahead of time for helping me out or pointing me in the right direction on this one. Here's my e-mail, just in case

[email protected]

[Vaughan]

OK, Part A is doable and relatively easy.

Part B is not possible because scripts don't work in layout mode. Besides, I have a feeling you don't need to copy and rename layouts. Whatever you want to achieve needs to be done some other way.

Part C seems to be doable too.

Hw to do it? In general, the first step is to back up your databases. Second step is to perform the processes yourself -- this is important because ScriptMaker doesn't work out how to do things for you.

When you have done the processes yourself, write down the steps (commands) that were needed.

Now open ScriptMaker, create a new script and enter the steps (listed on the left hand side) that correspond with the commands on your list. Test the script and trouble-shoot the problems.

Scripting is an iterative process. The task you have set yourself is quite a compicated one (especially part C). Work on getting Part A to happen first.