Jump to content

Related records


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

Recommended Posts

Im jsut bad with the logic of scripts...

I havd DB a and DB b with a relationship betwen the Last_Name field

trying to figure out how to make a button in DB a that goes to related record in DB b. This is easy enought to do. However, if there is NO related record it currently does nothing. I would like it to do something. Like if there is no related record go to the first record.

thanks!

Link to comment
Share on other sites

Steve ...

Here's a variation on Justin's example.

I'll repeat something that's been said over and over here: don't use names of any kind as the relational key field. Names change, and your relationships can break as a result. Relationships are best built between values that will never change.

That said, in this little demo, the "gRR_name" script first checks if there are any related records. If not, it gives the user options for how to proceed. It's just a simple example of how to handle situations where there are no related records.

Main_Related.zip

Link to comment
Share on other sites

This topic is 7342 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
×
×
  • Create New...

Important Information

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