Article View: comp.sys.ibm.pc
Article #41451RBase for DOS FORMS questions
From: Mark Robert Smith
Date: Thu, 01 Feb 1990 17:57
Date: Thu, 01 Feb 1990 17:57
28 lines
1651 bytes
1651 bytes
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
Technical Details
Message-ID:
<Feb.1.12.57.26.1990.21629@topaz.rutgers.edu>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!rpi!image.soe.clarkson.edu!sunybcs!rutgers!aramis.rutgers.edu!topaz.rutgers.edu!msmithShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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: <Feb.1.12.57.26.1990.21629@topaz.rutgers.edu> 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