Jump to content

Self-lookup


Jana
 Share

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

Recommended Posts

I want to lookup information from previous records for new records in the same table based on conditions where multiple fields all match.

Can anyone help me the basics for this relationship? I'm getting nowhere, but frustrated.

Unfortunately, I can't find the help I need in Search feature.

Thanks

Link to comment
Share on other sites

Make a second occurrence of yout table in the relationship graph and construct a relationship between it and your original table using the fields that you want to match.

You can then use this relationship as a lookup. It will copy the information from the first related record via the relationship.

Link to comment
Share on other sites

This topic is 5761 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.