M
msnews
Access 2000, trying to filter one table based on the contents of another.
Table A
A.ID =1234
A.FLAG = WHATEVER
Table B
B.ID =1234
I have the following select statement:
Set rs1 = db1.OpenRecordset("select B.ID, B.ListID, B.PartID, B.Qty from B
where " _
& "B.ListID=" & strParentID)
Multiple records will be returned from B and I'd like to further filter them
using Table A -- only return records from B if the field A.FLAG = "some
value"
TIA
Table A
A.ID =1234
A.FLAG = WHATEVER
Table B
B.ID =1234
I have the following select statement:
Set rs1 = db1.OpenRecordset("select B.ID, B.ListID, B.PartID, B.Qty from B
where " _
& "B.ListID=" & strParentID)
Multiple records will be returned from B and I'd like to further filter them
using Table A -- only return records from B if the field A.FLAG = "some
value"
TIA