I have to start a new one... my questions have from my previous thread has already been answered and resolved.

So here it is:

I have a two different sets of data that comes from two different tables (in one database). One table, unitorder, contains the columns pono (P.O. No.), orderno, unitordered, suppliername, price, quantity, and totalunitprice. The other table is the supplier that contains suppliername and address.

Now the only thing in common between the two is obviously the suppiername. In my program you cannot have two unit orders with different supplier, so in one transaction (Purchase Order) there is only one supplier.

The problem is I need the information from both of the tables, suppliername and address where suppliername is equals to the suppliername of a certain Purchase Order, and the details from the unitorder table to be displayed in one datareport. But since they are from different tables, I just can't do that.

So how can I make that kind of datareport? Or is there a much easier way or it just can't be done?