input fields, dropdown fields, new record in portals

[FranciscoMtz]

In my database there are 2 tables: 1 named "Project" with "project id" and "project name", and the another table for "Statement", related by "project id" field

 

I need to have portals like this example image: To have input fields that i can type any information, input dropdown fields, and a button to add new records to the portal. http://1.bp.blogspot.com/-8N4sZht1XQc/UhTmArnkkUI/AAAAAAAAAJM/msslQlA6oZM/s1600/portal-dropdown.bmp

 

I dont own the Data base from the image, not sure if the fields shown in the portal are from only one or many related tables, buy I just wanna know how to do it (input fields and dropdown) to try it on my database.

 

 

[Fitch]

Working with related tables and files

Defining a value list for data entry

 

To add portal records using a button, you would typically turn OFF allow creation in the relationship. Your button would use a script such as:

Set Variable( $parentID ; ID )
Go to Layout( child )
New Record
Set Field( parentID ; $parentID )
Go to Layout( original )