Jana Posted December 18, 2005 Share Posted December 18, 2005 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 More sharing options...
SlimJim Posted December 18, 2005 Share Posted December 18, 2005 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 More sharing options...
Recommended Posts
This topic is 6696 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 accountSign in
Already have an account? Sign in here.
Sign In Now