Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!rpi!image.soe.clarkson.edu!sunybcs!rutgers!aramis.rutgers.edu!topaz.rutgers.edu!msmith From: msmith@topaz.rutgers.edu (Mark Robert Smith) Newsgroups: comp.sys.ibm.pc Subject: RBase for DOS FORMS questions Message-ID: Date: 1 Feb 90 17:57:29 GMT Reply-To: msmith@topaz.rutgers.edu (Mark Robert Smith) Organization: Rutgers - The Police State of New Jersey Lines: 27 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