Query database with records from a recordset

[paulboreham]

Hi All,

Is it possible to pull records from a database from results from another recordset...?

For example, I have made a table to store a portfolio of properties that a customer can save. So in the table, I place the UserID and the PropertyID of the record.

I then have a recordset that pulls all the PropertyId's from the table that match that users UserId. So I now want to query the main Property database, pulling records that match the Portfolio Tables PropertyId's.

Does that make sense?!

Thanks for any help.

Paul

[vaaaska]

yep...relational stuff...it's not so hard...

WHERE table1.thisid = table2.thatid...

[paulboreham]

Thanks, but I'm still not sure that will work will it?

Surely that query will pull ALL the property ID's from the Portfolio table that match the Property ID's from the main Property table? I need the query to pull the Portfolio ID's that match ONLY the Property ID's of the current customer...

[vaaaska]

Post your table layouts...it's certainly doable but it's hard to say without seeing what you have going on...