Jump to content

Create portal record from script & "Paste" into it?


mattlight
 Share

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

Recommended Posts

I have a sales database with two seperate portals. One searches for a product code from stock control giving me stock available, price, description, etc. The other writes to a sales lineage database.

I select the product in the first portal and enter required quantity.

Then I click on a button "Add to Order" and it adds my quantity to the 'allocated' field in the stock control database and then copies the product code and quantity to the second portal and writes with it the invoice number, salesperson, client ID from invoicing database.

PROBLEM:

I can enter the first product perfectly. In the script I ask it to go to next portal row when entering the next copy and paste but it overwrites the first entry of the second portal.

I then tried to set up a field that increments+1 for every new item and get it to go to portal row by field value - still no joy!

Does anyone know how I can paste into the second portal record? (basically create new record and past product code and quantity)

Thank you

Matt Lightbourn - [email protected]

Link to comment
Share on other sites

2 portals on the same layout is problematic. Filemaker does not specifically identify portals, so when doing manipulation on portals you are really gambling on working on the correct one.

The prefered method would be to run a script in the related file which then does the function directly in that file on the specified record.

You are scripting this anyway so, it is just a matter of moving that functionality to the other database file and calling that external script from the invoicing DB.

Link to comment
Share on other sites

This topic is 7237 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.