Auto minus From link

27 views
Skip to first unread message

Prexyll Joseen Palma

unread,
May 7, 2020, 12:11:22 PM5/7/20
to mementodatabase
Good day,  Please help how can i auto minus from another library record after entry

Bill Crews

unread,
May 7, 2020, 12:58:24 PM5/7/20
to Prexyll Joseen Palma, mementodatabase
Can you rephrase that question, please? I don't understand what you are asking.

Ernst Moser

unread,
May 7, 2020, 2:39:12 PM5/7/20
to mementodatabase
Hallo
Wenn sie die 2 Datenbanken miteinander Verknüpft haben , können sie mit einen " Berechnungsfeld " auf die Daten zugreifen .

Hi
If you have linked the 2 databases with each other, you can access the data with a "calculation field".

Prexyll Joseen Palma

unread,
May 7, 2020, 5:18:36 PM5/7/20
to mementodatabase
i have 2 libraries 1. Receivable 2. Payment 

My Receivable Library has Field Balance
I need when i create new record in payment library will automatically update the field balance in the Receivable Library 
thanks 

Bill Crews

unread,
May 8, 2020, 5:57:31 AM5/8/20
to Prexyll Joseen Palma, mementodatabase
Ernst may be right if your link is a many-to-many link from Receivables to Payments, but if the link is a one-to-many link from Payments to Receivables, a pair of Triggers is needed, one to execute when a payment is first saved & another when the payment is later updated

Let me know which kind of link you have, and if it is the one-to-many link and if you know how to do this or if you know JavaScript at all. If not, wait for my next posting (some hours from now, as I need to sleep now) in which I will provide the solution to you.

Prexyll Joseen Palma

unread,
May 8, 2020, 8:32:49 AM5/8/20
to mementodatabase
Thanks for answering. Im using one to many

Bill Crews

unread,
May 9, 2020, 12:59:46 PM5/9/20
to Prexyll Joseen Palma, mementodatabase
I have to apologize. In addition to a medical issue I'm dealing with, I'm also delayed by a bug in my trigger script that I haven't been able to explain & fix. I'm sorry I haven't responded sooner. I'll send the template when I can.

On Fri, May 8, 2020, 8:32 AM Prexyll Joseen Palma <pre...@gmail.com> wrote:
Thanks for answering. Im using one to many

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/e25900c1-f9d9-4e1a-8344-bb92eaa59f6f%40googlegroups.com.

Prexyll Joseen Palma

unread,
May 9, 2020, 4:20:58 PM5/9/20
to mementodatabase
Thank you bill , Waiting and looking forward for your reply


On Saturday, 9 May 2020 19:59:46 UTC+3, Bill Crews wrote:
I have to apologize. In addition to a medical issue I'm dealing with, I'm also delayed by a bug in my trigger script that I haven't been able to explain & fix. I'm sorry I haven't responded sooner. I'll send the template when I can.

On Fri, May 8, 2020, 8:32 AM Prexyll Joseen Palma <pre...@gmail.com> wrote:
Thanks for answering. Im using one to many

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to memento...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages