I've got two databases, projects (PRJ) and employee names and email addresses (EMP). I'm trying to compare a last-name field in PRJ with a last-name field in EMP and, if EQUAL or even SIMILAR, put that employee's email address in a new field. I tried:

If (PROJMGR = Employee Table::Emp. Last Name; Employee Table::email;0)

But the comparison between the two text fields doesn't work.

Thanks for any help!

Steve

Edited January 30, 200718 yr by Guest

You are showing v6 in your profile, but you are talking about Tables. Prior to version 7, tables were separate files.

Using the Employee Last name is asking for the relationship to not work properly.

A better way would be to have Employee IDs, and they need to be unique.

The way you are saying you want to set it up will break when you have two or more people with the same last name.

Anyway, what you want is to Auto Lookup the data. You need a relationship between the 2 TOs (or files), and then have your email address in Project Manger To (file) looked up the information based on the relationship in the Employee TO (File).

HTH

Lee

Thanks for your quick response, Lee. Appreciate that! I'll give what you suggest a try.

Steve

Lee, (or others)

A follow-up question...I did what you suggested using the related link. I linked "employee last name" in EMP table with "project manager" in the PRJ table. Although I have a unique employee ID in EMP, it doesn't make sense to link it to PRJ because I actually have an ACCOUNT manager to fill in as well in PRJ. So, I tried relating "project manager" AND "account manager" to "employee last name", but that no longer works. Again, any help is MUCH appreciated.

Forgot to mention that I made the proj mgr and acct mgr fields look-up to the email field in EMP.

Steve M.

Edited January 30, 200718 yr by Guest

Verify that you are using v6, or somthing else before I make you a sample file. There is a big differece between Tables and Files.

Lee

Thanks Lee. I'm definitely using 8. All my dbs have the fp7 extension.

Steve

Here are a couple of examples.

I forgot about this Thread, as I got busy doing a project of my own. I put these together fairly quick, and they show how you can pull the Email address from the Employee file into the Project file. However, if you were going to need more information than this, then you would need to improve this using IDs, probably some Portals, scripts, etc.

The two file folder is the one I was doing in v6, and I converted over to v8.

BTW, all of 7, 8 and 8.5 files are tagged as v7.

The single file would be how you could set this up using TOs.

HTH

Lee

SMM.zip

Thanks again for your time working on this, Lee. That was a big help!

Steve