Ok Ill try again..
At the moment enquiries page displays Data from the "enquiries" table and the "property_enquiries" table. The user selects the data from the Select Enquiry by Estate" drop down menu. Each menu item sends its value to the url variable attached to there query that displays the data on the page.
The problem I've got is I want a form at the bottom of this page that a user completes during further correspondence ( phone call ). The form sends Data to a third Database table. As and when there is Data in the "further correspondence" table, I want to display this data at the end of the "enquiries" and "property_enquiries" data id displayed.
So when the user selects an option from the drop down it displays data from THREE tables.
SO my question is how do I set the "recordsets/queries" so they can send retrieve data form THREE tables instead of two?
I hope this is clear. If not I will forward a Skype username.
Thanks
