Querying and 'Tagging' Records

[jagstirling]

Help ! This is my first MS Access Project!

I am building a database for a real estate agent, and as such have tables of client details/requirements and properties available for sale.

I intend building a query that will match up a number of fields (number of bedromms, price etc).

How can I best build my query so as not to continually match the same properties to the same clients? I imagine I will need some SIMPLE method of identifying/tagging the properties for sale when the client has either viewed the property or has deemed it unsuitable. This would then not bring up these records when I ran the query a second time.

A SIMPLE method of remveing the 'tag' would also be useful.

Any suggestions appreciated. The simpler the better (I am only a novice) !

 

[ejstefl]

What is the structure of your database?

I guess what I would do, assuming you have a Client table and a Property table, is create a third table called ClientProperty. This table would contain the ClientID and PropertyID of any matches.

When you ran the query to find matches, you could append results in this table, along with the date appended (so you can tell what is new).

 

[jagstirling]

Thanks for the reply.

You are right in guessing the the structure (ie. 2 tables). Glad I have followed some logic so far !

Appending the properties and then using the date would allow me to see what was matched on a certain day but would not allow me to show when the client has either viewed the property or has deemed it unsuitable.

Can you think of a way of doing this ?

 

[ejstefl]

Well, you could add a date column called "Viewed" and a yes/no column called "NotSuitable." This would allow you track the date viewed if the client deemed the property suitable, or allow you to check UnSuitable if they did not.