I am assuming that when changing data in a portal that the foreign key for the child table automatically gets updated?

Example:

Invoice Items (in portal):

Product Number

Product Description

Quantity

Price

Extension

Note: The product number is saved in the invoice items table, as is the primary key of the product which is in a products file.

So if I use a popup in the portal for the product number field and show the product # and the description (calculation field) and they select another product, does the foreign key linking the invoice item to the product record change?

The portal data *is* the child data. No updating required.

I was having trouble with the value list lookup for the product. Finally figured it out. Works great and everything is updating.

Thanks Bruce.