Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Add a new record but stay on the same same form

I have two tables.  A Quality Records and a Defect/NCR/ CAR.  When creating a new Quality record, it becomes a Defect/NCR/ CAR.  I want to be able to click the button, create the Defect/NCR/ CAR but s...
Errors
Formulas and functions
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
no problem,
Just remove that last part & "&z=" & Rurl()  and you will "stick the landing", just like in gymnastics.

URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&_fid_345=" & URLEncode ([Record ID#])
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
The Child Table is Quality Records
The Parent Table is Defect/ NCR/ CAR.  
There was a grid edit on Quality Records that once the grid was complete (Defect/ NCR/ CAR Table),then a new record for Defect/ NCR/ CAR was created. 

I want to get away from using the grid edit.  It is too time consuming for my guys on the floor.  I created a simple form in Quality Record that when they click the button, it will create a new record in Defect/ NCR/ CAR table.  I would like one to create new Defect/ NCR/ CAR record and close.  Another to create Defect/ NCR/ CAR record and copy.  

I currently have a copy record button.