How to Split an Existing Order in several Shipments
There is an Order with OrderID
i now would like to Spit this Order into Various Shipments
but i'm struggling with the Script ...
Thank you for your Help
Your set field steps are using incorrect syntax. They should look like this: Set Field [ShipedLineItems::Shipping ID ; $ShipID ]
The extra pair of brackets tell me that you put the variable name in the repetition specification box--which is incorrect.
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.
Stuck again … the Order doesn't seem to split up ... i know i'm missing something here ..
What do you use to perform this script? A button in the portal row of OrderLineItems 2 should be used to perform this script--which would select that item for inclusion in what I assume is the layout's current shipping record. Looks like you also need more fields in ShipedLineItems so that you can see the product line item data appear in the upper portal when you select an item for the current shipping record.
Please note that you have not described the relationships and tables that you have set up so I may be making incorrect assumptions about the design of your database.
seems to produce a record .. but i'm missing out on a couple important details
Your script does not have any code for copying over the Order ID. But I don't see any reason why you aren't getting a ProductID here. Is there any chance that the record shown was created by an earlier run of this script before you corrected it?
If you have FileMaker Advanced, I suggest opening the script debugger and dataviewer and then clicking the button to perform this script in order to step through the script one step at a time.
Am I correct that you also have a relationship between Orders and Order Line Items not shown in your screen shot that matches records by Order ID?
Retrieving data ...