Combine two table fields in one list
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.