Forum Discussion

AyoubSalhi's avatar
AyoubSalhi
Qrew Trainee
8 years ago

How can I create a record in a table when I click in a button of another table (with conserving some values)

I have a "Requisition" table, with a button "Make into Purchase Order". Another table is "Purchase Orders" . I would like a button in the Requisition form when clicked, it would creates a PO with the...
APIs and custom code
Ask about Quickbase functionality
Forms
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Ayoub,
When you say it does not work, what are the symptoms of the problem.  What is the error message?
AyoubSalhi's avatar
AyoubSalhi
Qrew Trainee
8 years ago
Sorry if I wasn't too clear.

I don't have any error in my formula. The problem is that I'm not able to copy data from 'Requisition table' that are from other tables 'Vendor' and 'Requisition item' tables.

I want to copy data from 'Requisition' form to 'PO' form with a click of a button 'Make into a PO'
The requisition table has relationships with two tables which are : 'Vendor' and 'Requisition Items'.
The PO table has relationships with two tables which are : 'Vendor' and 'PO items'

Everything works great except :

 copying the 'requisition items' from 'Requisition' to 'PO'  &  copying the 'Vendor' data from 'Requisition' to 'PO' .

No errors in my formula but these two lines don't seem to copy the data from 'Req' to 'PO':
& "&_fid_34=" & URLEncode ([Requisition items])
& "&_fid_53=" & URLEncode ([Vendor])
Is it because they are data from other tables (Foreign keys), they need a certain method ?