Method Community


Creating Grid

Last post 03-07-2014 9:02 AM by Anonymous. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-07-2014 8:48 AM

    Creating Grid

    I want to create a grid with the fields below. I will need to sharsome of the fields between each other to get them all on one grid. What's the best way to do this?

    From "Invoice" Table




    From "InvoiceLine" Table:






  • 03-07-2014 9:02 AM In reply to

    Re: Creating Grid

    Hey Chris,

    Your best bet is to create linked fields on the Invoice table that bring over fields from the InvoiceLine table, then base the grid around the Invoice table and share all of those fields. You can create a linked field for every field on InvoiceLine that you need. Now, based on what your'e describing I'm assumign you want a grid of all the invoiceline items you have assigned with the invoice information, correct? In that case, you likely want to do the opposite, and add the AssignedTo, Customer and TxnDate of the invoice as a linked field on the InvoiceLine.

    Let me know if you need further clarification on this one. I can send over some screenshots of the process if that will help.


Page 1 of 1 (2 items)