AnsweredAssumed Answered

Set Field does't seem to push data into the wanted field

Question asked by pietergorisio on Jun 22, 2017
Latest reply on Jun 23, 2017 by pietergorisio

Hi FM'ers,

 

 

I know, I'm busy with a lot of questions lately. But I'm building a touch device interface and running into a heap of problems lately.

I was hoping you guys could think along with me.

Here is a graph of one of the many relationships.

 

Screen Shot 2017-06-22 at 19.25.36.png

 

What I'm trying to do is get in Invoices::ContactIdFk (number) the ID that you can find in Contacts_Invoices::Id (Number, auto serial)

with the Set field (on button click). It seems it runs the script but ContactIdFk stays empty.

I'm trying to select the client for a specific invoice from a list with all clients.

 

The script I use when button click is:

 

Set Field [ Invoices::ContactIdFk ; Contacts_Invoices::InvoiceNumber ]

Go to Layout ["CreateNewInvoice" (Invoices) ]

Go to Object ["Object Name: "tab-chooseclient" ]

 

Hope you guys could teach me another thing or two. Because I don't see what I'm doing wrong here.

But it might be a foolish mistake

 

Much appreciated!

Outcomes