Thanks for the help. I created the view on the first table as you suggested Emmitt, and it worked. I do not remember having to do this on the other forms I use that have similar situations. One could always use a temporary view in the same way, couldn't they in the on before design EEP?
Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Friday, February 27, 2009 8:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORM QUESTIONS Are you also going to edit data in the first table? If not, create the view on the first table. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, February 27, 2009 9:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORM QUESTIONS I will need to edit the information in the second table. You cannot edit a view, correct? ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Friday, February 27, 2009 8:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORM QUESTIONS Jim: What you need to do is create a view of the second table where you rename the column so it matches the column in the first table: CREATE VIEW your_new_view_name (NUMPART,...other_columns...) + AS SELECT PARTNUM, other_columns...FROM your_second_table name + WHERE your_where_clause Now, use the new view as you second table and you will have matching NUMPART columns that will allow the link. Javier, Javier Valencia 913-915-3137 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, February 27, 2009 8:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - FORM QUESTIONS 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
