Add item in line item portal from another portal 
Author Message
 Add item in line item portal from another portal

Hello,

I'm using an Invoice type layout with two portals: one containing
product info storing product number in a field called ProductCode when
selected.
The other (LineItem) is used to add the product that will be sold to
the invoice. Relationship between lineItem: InventoryID and the main
InventoryID of the Invoice file.

Problem.  I have this script that is activated when I click on a
product in the list.  However, I don't know how to go to the next
record in the lineItem portal before pasting the next product.  This
script always replace the first line in the portal.

Copy (Select, "ProductCode")
Need to go to the next record in the LineItem portal
Paste (Select,"LineItem::InventoryID")
Go To Field []

Thanks for any help !!

Matt



Sat, 16 Oct 2004 21:57:05 GMT
 Add item in line item portal from another portal

Quote:
> Problem.  I have this script that is activated when I click on a
> product in the list.  However, I don't know how to go to the next
> record in the lineItem portal before pasting the next product.  This
> script always replace the first line in the portal.

> Copy (Select, "ProductCode")
> Need to go to the next record in the LineItem portal
> Paste (Select,"LineItem::InventoryID")
> Go To Field []

When you have two portals on a layout, the safe way to make sure you go
to the right portal is with a Go to field step. Follow that with a go to
portal row. If you are always adding to a list, you don't need to
specify a row by number, just go to the last row:

Copy (Select, "ProductCode")
Go to field (LineItem::InventoryID)
Go to Portal Row (Last)
Paste (Select,"LineItem::InventoryID")

If you do need to go to a specific row, use a global number field, and
after each paste, set it to Status(CurrentPortalRow) + 1. So then you'd
replace step 3 of the script above with a go to row by field value:
Go to Portal Row (gCounter)

Tom Fitch
Fitch & Fitch
Portland, Oregon



Mon, 25 Oct 2004 04:18:36 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Portal for line of data in a portal?

2. Portal Items to one field

3. select an item within a portal, one-click switch

4. Listing the Items in a Portal in a Horizontal View

5. Selecting 1 item of a portal

6. Add additional items to Unselected items in SQL Profiler for SQL Server 7.0

7. FILTER PORTAL RECORDS - DISABLE ADDING NEW RECORDS IN A PORTAL

8. Using Portal on a report to display relate line ites---require it to adjust to the amount of lines items

9. Changing items select statement causes different results for other items

10. Oracle Portal vs Novell Portal

11. SQLMenu50, enable item, disable item

12. To Portal or not to Portal


 
Powered by phpBB® Forum Software