single purchase order with multiple invoices

[vz4ever]

i have a table which has po number, po line, invoice number, inv line
columns. key field is the purch order + po line. i can't figure out how to
set a query that will take the inv numbers and have them align in different
collumns, to the right of the key record, as opposed to lining up in a single
column.

 

[Duane Hookom]

You can display records horizontally by using columns in your page layout. If
that doesn't resolve your issue, you need to come back with more specific
information about your tables and desired display in the report.

 

[vz4ever]

po nbr po ln inv nbr inv ln
123456 001 225632 001
123456 001 225846 001
123456 001 237257 002

Instead of the po nbr repeating for every inv nbr, i want the po nbr to be
appear once, in the table, each asociated invoice would appear in collumns to
the right, same row.

po nbr po ln inv nbr1 inv nbr2 inv nbr3
123456 001 225632 225846 237257

 

[Duane Hookom]

You create a main report based on the PO without any invoice records. Then
create a subreport based on the invoices that has multiple columns. Add the
subreport to detail section of the main report.