Hi all,

Am trying to create records in a portal but have been encountering problems when trying to move off the layout that has the portal. I get the following error message:

"pk.pt_id is defined to require a value, but it is not available on this layout. Use another layout to assign a value to this field"

pk.pt_id is the primary key by which the two tables are related and the privileges are set to allow record creation etc. I am assuming that this is a relationship problem but could of course be wrong. Another user of the system (data-entry level user) then gets the option to revert or cancel, the only way she can get around the problem is to revert the changes and she loses all the records that she has just entered into the portal.

Any thoughts anyone?

Thanks in advance for the help.

The table with the portal should have field pk.pt_id defined as an autoentered serial number. This field should be set so that the user can not modify. You do not need to validate this field to be unique or not emp[ty.

The other table should have field pk.pt_id defined as the same type, i.e., number or text, as the field in the first table.

If your relationship is set to allow creation of related records, adding data to the last portal row will create the related record and enter the key value into the new record in the second table.