Hi everyone,

I created a view, which is based on two tables. One table from Stats database (this is the one which is relevant for this application) and another table from JobControl database, which I used only for display purposes (I want to show customer name from customer table). My colleague suggested to use just tables instead. Well, I still want to use p-view, but I'm thinking, may be instead of adding customer table into my view, I can put seek(oJC.CustID, JobControl!Customer, CustID) into the controlSource for this textbox on the form (it's for display purpose only). What would you suggest?

The form only uses one record from Stats!CustomerInfo for the customerID=oJC.CustID

Thanks in advance.