I am sure this question has a simple answer but I am stumped. I want to create a form that will connect two tables that do not have columns that are the same name but the columns contain the same information. The first table in the form will be either a DBGRID or a SCROLLING region. No problem. The second table will have just one row based on the row where the curser is in first table. The names of the two columns are NUMPART and PARTNUM. They are the same information just a different name.
No matter what I have done (including clicking on the many to many relationship) the second table brings up ALL the information in that table, not just the information based on the row in the first table where the cursor resides. I have created these relationships before and have the forms up and running but am at a lost with this one. Sorry to bother you with the mundane. Jim
