I have a table that contains the fields:
Fr--street name
To--cross street name
Node--The unique id for the intersection (this is only unique in that it describes a single point in space, not a unique record)
This table contains duplicates, i.e.:
Fr ______________To _____________ Node
8 ST NW ________2 AVE NW________101
2 AVE NW________8 ST SW __________101
It is possible that more than 2 records could have the same Node
I do not maintain the database that the table is created from and cannot change the design of the table in any way; I can however run any queries, or make tables to manipulate the data.
I have a form and am able to get the first combo box (Street) to work, and the second combo box (cross) to provide a list of only valid cross streets.
The problem is I cannot get the third control (ID) to populate with the value for node.
The closest I can get is
Expand|Select|Wrap|Line Numbers
- Private Sub cross_AfterUpdate()
- id = "select node from intlist where street.value=fr and cross.value=to"
- End Sub
I have no idea where to go from here
Any help would be greatly appreciated.
I am working with access 2003 and windows xp professional.