I need a database constructed that will allow me to enter a list of investors and match them with property from a list. There also needs to be a function that selects an appropriate list of properties for an investor.
The property records have characteristics such as:
Zip code, area, type, zoning, condition, neighborhood, various random tags
The investor records will have characteristics such as:
Name, address, telephone 1, telephone 2, fax, email, referred by, notes, etc
In addition the matching functions will be multiple selections that match the property characteristics as well as a place for random tags. So that an investor can select multiple zip codes, neighborhoods, types, etc. There needs to be a provision for excluding characteristics as well. Some characteristics such as "area" will have to be specified as less than < or more than > ">1200" . And as there will be multiple selections a range can be specified.
In conclusion when complete I should be able to select an investor and pull up property matches as well as select a property record and pull up matching investors. The output should be in the form of an exportable list and screen output.