Jump to content

Marking a Record if it Matches field in another table


Skwerrl
 Share

This topic is 5741 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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";"")

Link to comment
Share on other sites

This topic is 5741 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.