I'm building a report...it's actually an invoice letter. On top, there's a field, Customer PO.
There's a main table, table A, and a second table, Table B. This field is in Table B and this table can have several rows with CustomerPO that relates to the main table, table A
I'm displaying CustomerPO on top of the report.
Is there anyway to have 2 SQL statements in a dataset? one to bring the customerPO and one to bring the rest of the data? I don't think because I tried it and "query designer" threw an error. Looks like there can only be one select statement.
Do I need to create a second dataset?? (I just thought of that)