2 Replies Latest reply on Nov 29, 2011 10:34 AM by RedL

    Combine two table fields in one list

    RedL

      Title

      Combine two table fields in one list

      Post

      Our system allow users create Invoice or Sales Order independent.  Each Invoice and Sales Order will have unique customer PO number.  Use Value List feature, we can create PO list from either Sales Order or Invoice table with date range filtering.  We would like to combine both tables PO number to one value list.

        • 1. Re: Combine two table fields in one list
          philmodjunk

          Merging your two separate tables would seem the simplest solution here. Why have separate tables?

          You could set up a separate table with one record for each Sales Order record as well as records for each Invoice record, but you'd need to script a process that creates a matching record in this table each time an Invoice or a Sales Order record is created. Then you could base your value list on this table--but that seems very cumbersome when compared to simply putting all Sales Order and Invoice Records in a single table. You can add a field to such a table to use to identify each record as one or the other so that you can work with just one type of record at a time...

          • 2. Re: Combine two table fields in one list
            RedL

            Understand and thanks.