Filemaker: Copying records from one table to another

Question

I have a database with tables ( case, knowledgebase)

Case table has fields linked to a specific customer

Knowledgebase table is separate and doesn't care about customer.

I want to have the user click a button occasionally to copy their solution (from Case Table) to a new record in knowledgebase table (just two fields, desc, solution)

I just don't know the steps to 'copy'

Not sure what application and DB are you using and if you want to it at the application level or database level - Can you please clarify that in your question — Hussain Patel, Aug 21 '17 at 22:55

score 3 · Accepted Answer · answered Aug 22 '17 at 02:46

3

Roughly:

Set Variable [$desc; Value:  Case::desc]
Set Variable [$solution; Value:  Case::solution]
Go to Layout [ Knowledgebase ]
New Record/Request
Set Field [Knowledgebase::desc; $desc]
Set Field [Knowledgebase::solution; $solution]
Commit Records []

answered Aug 22 '17 at 02:46

michael.hor257k

113,275
6
33
51

I couldn't understand the question, until I read your answer. – Nicolai Kant Aug 23 '17 at 10:21

Filemaker: Copying records from one table to another

1 Answers1