I am working in ms access database2000 and my frontend is vb 6.0.
I have three tables namely:-
The field areaids in ROUTE table consists of chain of areaids belonging to that particular route in this format '12,23,65,67,'
The problem is that i want to derive a query which is able to retrieve records from ROUTE and PARTY on the basis of a particular area.
response is required as early as possible.
thanks in adv.