I am writing an application that generates a report. Essentiall their is a parent database and several children. The child db's comprise the major chapters / sections. Subsections within each chapter are handled through concatenated portals, based on the primary key from the parent, and whatever subsection id I assign. For example: 1|2 means the primary key "1" from the parent and the second subsection. In this way, the major sections or chapters in the book can change in size as needed.

My question is this: Can you limit a subordinate database in a portal to only one record? and if so, what is the most efficient / professional way to do so?

Thanks in advance!

Sincerely,

FMJoel - fellow propellerhead.

You could skip using a portal to display the related fields. If the fields are on the layout and the relationship allows creation of related records, you'll still be able to create the first related record through the relationship.