Jump to content
The ORIGINAL FileMaker Community - Forum - Online Business Apps & Software Forum
bavan

Change invoice nr causes article qty price etc. lines to be reset/blanked

Recommended Posts

bavan

As prospect I've been looking into the dbase and relations of the 'Invoices' template (FMP11/12). If I fill out an order and after that change the invoice number manually, all orderlines are gone. The box 'Prohibit modification of value during data entry' is not checked. The box 'Allow user to override during data entry' is checked.

What setting is causing this?

Share this post


Link to post
Share on other sites
doughemi

Invoice line items are in a separate table. A relationship has been set up between the invoices table and the lineItems table using the invoice number as a key. (invoices::invoiceNum = lineItems::invoiceNum). By allowing the user to change the invoice number, the relationship has been broken, and line items can no longer be seen. Changing the invoice number in the Invoices table does not change the invoice number in the lineItems table.

 

Why would you want to change an invoice number?

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use