I am working in ms access database. and vb 6.0 is front end.

I have three tables namely:
AREA:= AreaId,AreaName
ROUTE:=RouteId,RouteNo,RouteName,AreaIDs
PARTY:=PartyId,LastName,FirstName,Address,AreaID

The table ROUTE contains the field AreaIDs which is chain of areaids belonging to that particular route and is stored in this format '12,13,34,'

now the problem is that this field type contains chain of areaids and is of string type(field type) but AreaId field of AREA table is of number type.

I want to retrieve records from ROUTE and PARTY table on the basis of a particular area.

response is required as soon as possible.