Action scripting for new record in Child Database

[Michael Thompson]

Why is there no action script to allow the creation of a new child record in a form? You can add a record in an embedded browse but there appears to be no action scripting commands to then open a form for the new record.

[forskare]

RE: Action scripting for new record in Child Datab

Michael, there is. Look a bit closer when you choose the form.

kenn

[eeetee]

RE: Action scripting for new record in Child Datab

hi:

action script "xbasic enter record" will do the trick, then refresh the form "refresh display".

regards,

ed

p.s. the action scripting is great after you get used to it. i forced myself to write an entire app using it to get used to it and glad i did.

[Michael Thompson]

RE: Action scripting for new record in Child Datab

If you choose a form then when you try to execute you get the error message that the form does not exist. Any other way it does not fill in the linking fields so the record does not have the parent to child link. I have failed to find any documentation for what has to be a very basic and often required situation. Maybe the choice that is there is supposed to work but has a bug. The option to add a new record in an embedded browse works but the child has too many fields to use a browse. Adding the new record and then trying to switch to the form view also fails with the error that the form cannot be found, or that the query is empty.

[Michael Thompson]

RE: Action scripting for new record in Child Datab

This application has to be developed without using xbasic. I am required to only use the action scripting to prove the value of Alpha 5 for users with no knowledge of coding in Xbasic.

[Michael Thompson]

RE: Action scripting for new record in Child Datab

That command allows you to create a record and set values. It dow not allow the selection of a form to enter the data.

[forskare]

RE: Action scripting for new record in Child Datab

Michael,

Let's start from the beginning. How is this set up? Do you have a form based on a set with an embedded browse based on the child table?

Do you have a subform on the form or are you going to a dialog form? Either way, the subform and the dialog form MUST be built at the child table level. You cannot use the fields of the child table if the form is based on the set level.

Assuming the subform is based at the child table level, action scripting will allow you to chose the subform in which to enter the new record.

kenn

[Michael Thompson]

RE: Action scripting for new record in Child Datab

Ther is a master record with a one to many child. I have the form defined at the child level. There is an embedded browse to the child on the form at the set level. If you try ot open a new record in the form at the child level you get an error message that the form does not exist.

[forskare]

RE: Action scripting for new record in Child Datab

Can you zip the file and attach it? You only need to include 1 record.

kenn

[Michael Thompson]

RE: Action scripting for new record in Child Datab

Here is the file. The action is on tab 4 it Initiative detail. The Milestone tab.

[forskare]

RE: Action scripting for new record in Child Datab

Got your zip but what form should I look in?

kenn

[Michael Thompson]

RE: Action scripting for new record in Child Datab

The button is on tab 4 of the Initiative_Detail form. The Milestone tab.

[forskare]

RE: Action scripting for new record in Child Datab

Michael,

Delete the button and create a new one. This time place it on the form. It cannot be on the tabbed object. I did that and it worked fine.

You might want to create a 'dummy table with one field, call it what you want. The base all your menu forms on the dummy table.

kenn

[Michael Thompson]

RE: Action scripting for new record in Child Datab

That won't even take the name of the form. The error message says specify level and there is nothing in the dialog box for the level. When you specify "Another Form or Browse Window at the top of the dialog box the level information vanishes from the dialog box.

[forskare]

RE: Action scripting for new record in Child Datab

Michael,

You must open the form before you can enter a new record. Make sense?

1.I created the button and chose action scripting.
2. Choose Form/Browse in the catagory section.
3. Choose Open Form or Browse Layout in the Action section, clicked OK.
4.Next, the default is form and all forms are listed. I chose Milestone and clicked Next. (If you click the Options tab, you can select a modal view for the form)
5. I chose no additional selection criteria and clicked finish in teh Catagory side and Enter new record is and then finish again.

Now to enter the new record.

1. Click records already selected on the Action side.
2. Click OK and then choose Another Form or Browse window.
3. Choose the Milestone form and click Next.
4. Click finish

The attached jpg will show you how it wil look when completed. When I tried to enter a new record, I did get the message but the form did open ready to enter a new record.

FWIW, I'd give some thought to redesigning the app. There's a lot of stuff and it's hard to say what's causing the error message. I'll play around a bit with it but give this a try and see what you come up with.

kenn