simple agent/commission report

[pbaldy]

So you want to have the same property listed more than once in the property table? I wouldn't, but it's your baby.

[smil27]

" You can use a combo for the property and use this to display the related info:

BaldyWeb - Autofill"

When you say use a combo for the Property, you mean a box to enter the PID in the field and then with this code: SELECT PID, Address, City FROM tblProperty to display any related info already in the table, if its already there.
I changed the main form from being bound to the both property table >> SELECT [tblProperty].[PID], [tblProperty].[Streetaddress], [tblProperty].[City], [tblSales].[Closed Date], [tblSales].[Sellingprice], [tblSales].[commissionpercent], [tblSales].[TotalComm], [tblSales].[PendingClosed], [tblSales].[Nettooffice], [tblSales].[Buyers], [tblSales].[Sellers], [tblSales].[ReferralOffice], [tblSales].[SalesID] FROM tblProperty RIGHT JOIN tblSales ON [tblProperty].[PID] =[tblSales].[PID];

To this: SELECT [tblSales].[Closed Date], [tblSales].[Sellingprice], [tblSales].[commissionpercent], [tblSales].[TotalComm], [tblSales].[PendingClosed], [tblSales].[Nettooffice], [tblSales].[Buyers], [tblSales].[Sellers], [tblSales].[ReferralOffice], [tblSales].[SalesID] FROM tblProperty RIGHT JOIN tblSales ON [tblProperty].[PID] =[tblSales].[PID];

What do I do with the FROM part at the end?