msmith@topaz.rutgers.edu (Mark Robert Smith) (02/02/90)
I am running RBase for DOS v2.13 Beta Unlimited (for a bug fix). I am trying to do the following: There are three tables which are important, A, B, and C. The form is based on table A. A and B have one field in common - field1. A and C have two fields in common - field1 and field2. A and B have a One-to-One relationship. Also, A and C have a One-to-One relationship. What is the proper way to implement this in a form? I currently have the fields placed on the form with B and C having no region and the Is this the MANY side question is No. table C has an expression on the form that says field2 = field2 IN A where field1 = field1. However, new rows are being created in table B and C when the user Edits the form. Also, if the user does not enter data for any fields in B and C during the Enter phase, you cannot edit them in the form. What am I doing wrong? Mark -- Mark Smith, KNJ2LH All Rights Reserved RPO 1604 You may redistribute this article only if those who P.O. Box 5063 receive it may do so freely. New Brunswick, NJ 08903-5063 msmith@topaz.rutgers.edu