1 2 3 4 Previous Next 57 Replies Latest reply on Oct 20, 2015 4:56 PM by Avengelyne

    Invoice and Clients

    AndrewJudd

      Title

      Invoice and Clients

      Post

      Hi all, I'm trying to copy a function in the starter solutions, invoice database.

      The one where you can click the popover and choose from your customer (client) table list. I've got as far as the popover displaying data from my client table correctly, and the cursor does change to the hand symbol. When you click it it states the field is not modifiable..

      I think I need a script (or a button?) to make the data in the popover get pasted into the invoicee name and address field (and the popover close). Surprisingly difficult step.

      I've attached a screenshot of my relationship tables in case that is helpful..

      If I can get this working I assume it will be straightforward to lift and pull data from my inventory table (in this case artworks) and have a similar button / operation for choosing which artwork is being added to an invoice - as a final step I want the artwork table to change field status to "sold" when an artwork is invoiced.

      THANKS!

      Screen_Shot_2014-12-23_at_14.38.02.png

        1 2 3 4 Previous Next