Jump to content

Can't create more than on record in subform


Kevin Cheesman
 Share

This topic is 5724 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

This is probably a simple mistake but I'm used to MS Access so FileMaker seems a bit strange at the moment. Please be gentle!

I've made a form which is my Contacts table. I have a portal which lists fields from my Contact History table and joined them on the ID field. I want to show records in the portal that relate to the records on the main form records.

On click of a button, I can update the first record in the portal with time of call etc, but on further clicks, the same record is updated when I need a new record to be added.

Can anyone help?

Link to comment
Share on other sites

Hi Kevin

put the button into the top row of the portal in layout mode.

The button will then appear alongside each row in the portal and if you have 'allow creation of records' switched on as an option in the relationship that is used in the portal you will also have a new blank record at the bottom of your portal.

Clicking the button will then apply the script steps, where applicable, to the portal row that the button was clicked in

HTH

Phil

Link to comment
Share on other sites

Hi Phil,

Thanks for that but...

I don't want to touch the portal and need it locked to prevent user alteration of the information in it. The portal needs to just show information created by actions on the main form and show a history of those actions.

What I need is to 'on click', create a new record with information copied over from the main form but I can only seem to alter the current record in the portal.

Kevin

Link to comment
Share on other sites

Ok then would this do what you want (I am assuming here that the portal shows data from a table in the same file and not an external file.)

In the script that you have attached to your button try this

Freeze window

Go to layout(any layout that shows data from the related file)

New Record /Request

Set field (uniqueID;Get(ScriptParameter))

Set field (anyotherfield;whateveryou want)

...etc...

commit record

go to layout 'your original layout'

Refresh screen.

When calling this script if you attach the current record ID as a script parameter you should see nothing happening on your screen except the new record and the required data associated with it showing in your portal

HTH

Phil

SEE ATTACHED DEMO

update_portal.zip

Edited by Guest
Link to comment
Share on other sites

This topic is 5724 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.