I'm not sure I'm even phrasing the question properly, but here's what the problem is.

I'm a Realtor, and have set up several database using the 8 digit MLS number to relate the two databases.

One database [TOUR] has Broker Tour Information (Tour date, time, Realtor Name, Real Estate Company Name, Comments, etc.)

The other database [HOMES] has information for each property, organized by MLS number.

The MLS number uniquely defines a property at any given time. A home can have several different MLS numbers, depending upon if it was on the market before, but the MLS number uniquely defines a property for any given marketing period.

The TOUR database has the real estate company name [Coldwell Banker, RE/MAX, Prudential... ], but when I try to view the company name in the HOMES database, sometimes it shows, sometimes it doesn't

I don't know if the name makes a difference. The field is called "Listing Office _ Office Name" (I import it directly from the MLS and that's the name it gives for it)

Someone suggested not using spaces, so created a new field "calc_listing_office_name" which is a text field calculated [=Listing Office _ Office Name].

What's odd is that some company names show just fine (I can click on the record and edit it) and others don't show up at all.

Any thoughts? Let me know if you need me to include screen shots or explain it further.

Ira Serkes

sometimes it shows, sometimes it doesn't

Could this be interpreted as "it is showing all the time, but some records don't exist"

As the only linkage is the MLS number then each related TOUR record needs to have the real estate company details re-entered each time.

Of course, if you create a new table of REAL_ESTATE_COMPANIES, and link TOURS to it with a "related_field_id", then you would only need to select a company from a drop down list (in TOURS) and the rest of the company info would be automatically related.