I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact information. This should be done when I double-click on the DBGrid, which opens another form where I will have the contact and company information displayed in labels and a text box to input a journal entry.
My basic problem is that when I click on the grid the SQL statement I have written is not working where I have it selecting the information form the current table and comparing it to the DBGrid column index value for the CompanyId.
Any ideas on how to make this work?
Although this is a front-end problem and beyond my expertise, I would suggest that you create a non-updateable view, the requery of which you could refresh when you change pages.