Setting Up and Configuring Relationship for Two Tables
I have two layout tables both have very similar information. How do I setup the relationship so that I can search for a record in Table 1 that is in Table two. I have played with the relationship table in the manage databases but I am not having any luck.
"very similar" in what ways? So similar that you could use one table where you now have two tables?
If a record in table 1 "is in table two" what values in what tables have to match?
This sounds like a case where you mmay have the same data entered into two different tables--usually not a good design to use in a relational database.