Search results for query: *

What I didn't get in there is I need a button in the portal to create new record related to portal record, but in the related table.

I am using a portal to create new records in a related field, however, each time I enter new data it only makes 2 records in the relating table and updates them with the last 2 I entered.

I figured it out; just have the portal show the empty(waiting for input field, and when you enter it it creates a new record. Now my question is how can I have 'Main' require this field? i.e. you cannot go to another record or layout/table without entering this field.

I have a table, 'main' that has most of the entered data (the parent), I have two other tables one for admission info , one for departure info. These will have multiple records, i.e. a client may come in and out of the shelter several times. I am struggling with the relationship, how do I get...

I created a table: Admission Date, I want to keep records of the admission dates, i.e. create a new record using the ID number from the parent so I can display the last 4 admission dates. I set them in a single record portals only sorted decending order in different places. Unfortunatly if I set...

Thank you, I am a novice and didn't understand most of that. I am a newbie to databases and am having trouble , I want to set up a relationship between two tables such that an entery in the parent table creates a new record of Admission date and have the last 4 old records be displayed in...

I am trying to get a filed to display the last admission dates and I get nada. What I have for the field calc. is : field= If ( (Count ( Admission date))<2; ""; GetNthRecord ( Admission date; (Count ( Admission date))-1) ) I thought this would go: If there is only one record return nothing if...