Hi all,
I have a dblist which I am feeding with an SQL statement combining several fields into one.
However, when I click on one of the items, I would like to be able to relate to the original record in the database table. Is there any way of doing that?
This is what it's for. I have a table with all the unique addresses (street + suburb + postcode) in Australia. There's about half a million unique entries. The program asks for the postcode and pulls out all the streets, followed by the suburb, followed by the postcode. Now, since a dblist can't have multiple columns, I have combined these three fields into one with an SQL statement so that they fit in the same dblist. When I click on one of the items, I would like to be able to feed separate text boxes with the street name, suburb and any other relevant fields that may be added like the area phone code. Since these fields are combined into one, I cannot use the text or boundtext properties. Each of these entries also has a unique ID that I also need to pull out.
So, is there any way to point to the selected record in the original table and pull out the required fields? Any help on this matter would be much appreciated. It has been driving me nuts for some time.
