Script for Stock transfer

[moj6054]

Hi, every one.

I have a problem with stock transfer.

I have a product table, order table , and stock transfer table , this table related with PK to each other.

My Problem:

I want, when create a order, when a product out of stock (in stock transfer layout according order number), I can see this change in order table, for example color of this product change to red or status of this product say SEND.

thank you for help me.

[moj6054]

Hi,

I think developer in https://fmdev.filemaker.com/ are very active than this forum.

[eos]

Why don't you post your file? That would make it easier to help you.

[moj6054]

I send my question here for long time, no answer.

But on that site, very soon answer to my question.

OrderInvoice.fmp12.zip

[eos]

have a product table, order table , and stock transfer table , this table related with PK to each other

There are 4 tables in your database: Orders, OrdersDetails, Invoices, InvoicesDetails.

I see neither a Product nor a StockTransfer table. So what does ProductCode refer to?

Are you sure you sent the right file?