Marking a Record if it Matches field in another table

[Skwerrl]

I have two tables. One of them has all of the values that are used to fill in different fields in the second one. I am trying to find a way to mark the original list if the name has been used in the second table. I have created a complex script which goes through individual records from each table comparing each to perform this, but I am looking for a way to expedite the process because once my database gets larger, this will take forever.

I have a relationship set up between the two tables linking 'Species List:speciesname = Database:speciesname'. I want to put an 'X' in the field 'Species List:Vouchered' if 'Database:speciesname exists'.

Let me know if this is confusing, or if you need more explanation.

[aldipalo]

I think you can simply set up 'Species List:Vouchered' as a calc field:

if(Species List:speciesname = Database:speciesname;"X";"")

If you set it up as a drop down you can use "Yes."

I don't use a lot of check boxes, but, I believe the same holds true as well.

If you just want to check to see if there is a name in the field then something like this:

if(not isempty('Species List::speciesname');'Species List::Vouchered'="X";"")

[Skwerrl]

Thank you. I don't know why I was making this so difficult.

[aldipalo]

Glad to help. Only trying to pay back the VOLUMES of help I have received from this site.

Al