Hi All
I currently have a customer tracking application I am trying to produce. I have one form with the main details which are held on the customer table eg name, address etc.
There is also a comments field, but as the main form is quite busy i would like to open up a new form with the same record but just showing the comments field.
I have been able to pass the ID and customer name through to the new form on the labels, I was wondering - could anyone advise how i could possible filter the table to display the correct comment for the correct customer.
Or, if anyone could advise of a better way to do it?
Thanks
Dan