Hi

I am trying to setup backend Admin section, where 1 table contains Table 1. Landlord Details, Table 2. Letting, Table 3. Sales

MS Access DB Relation is like - Landlord Details Contain (Property_ID) = Letting (Property_ID), Sales (Property_ID)

From DMX, I am trying to setup a page for landlord details where a small Image thumbnail contains with the Property_ID from table either sales or letting Image Name......

How can I pull the right image by searching from both table, it could be in the letting tables or sales tables depend on Property_ID

Please help me, I am stuck in this particular problem......I will realy helpful

Regards


Babu

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi

I am trying to setup backend Admin section, where 1 table contains Table 1. Landlord Details, Table 2. Letting, Table 3. Sales

MS Access DB Relation is like - Landlord Details Contain (Property_ID) = Letting (Property_ID), Sales (Property_ID)

From DMX, I am trying to setup a page for landlord details where a small Image thumbnail contains with the Property_ID from table either sales or letting Image Name......

How can I pull the right image by searching from both table, it could be in the letting tables or sales tables depend on Property_ID

Please help me, I am stuck in this particular problem......I will realy helpful

Regards


Babu
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

On the Landlord details page - I need add a Image thumbnail - according the ID from Table 1 + from table 2 or 3 (which ever contains the same ID), here is the problem, I am not sure how can I create the recordset for pulling the image name from table 2 or 3.....


Babu