Jump to content
Sign in to follow this  

Moving information between portals

Recommended Posts

To anyone who can help;

APPLICATION: FileMaker Pro 4.1

PROBLEM: Scripting a button

SCENARIO: There are 3 relational files. PI (Product Inventory), I (Invoice), and LI (Invoice Line Items).

'I' contains 2 portals, one for "PI" and one for "LI". While in "I", I want to click on a field "Model No" in the "PI"

portal and paste it in the "Model No" field in the "LI" portal. I want the paste function to happen in the next

available empty "Model No" field in the "LI" portal.

I would also like to know if there is an efficeint way to delete portal rows from the main file.

I extend my thanks in advance for any support.

binkel @excite.com

Fax: 860-563-8421

Share this post

Link to post
Share on other sites

The only trick in pasting an item from one portal to another is controlling which portal you are in. Go to portal row takes care of the row selection once you are there. The portal/row is select with the "Go to field" scrpt step followed by the "Go to portal row" script step.

There are really two options for this whole process:

1) Don't use portals at all for the addition of a product to an invoice. Write a script in LI that creates a new record, sets up the index to associate the record with the correct invoice in "I", and sets the product number to the correct value. I wouldn't use cut and paste for this, use "Set Field". You can create global fields in "I" and access them from LI using a constant relationship (calculated field = 1 in "I" related to calculated field =1 in "LI"). Create two global fields and use one to pass product number and the other to pass the index for the invoice.

2) The other option is to use "set field" and "Go to portal row" to accomplish the creation using two portal in "I".


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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