Forms

  • Thread starter Thread starter skk
  • Start date Start date
S

skk

Hi All,

I've created a form using multiple tables for data entry. If I do not fill
in all entries in the form, my form record count at the bottom will not count
the entry. I will have the data in my table but I do not see it in the form.
I have set my relationship to 1 to 1 with a primary key. How do I
capture/count all records in my form?

Please Help.

Thank you
 
Hi All,

I've created a form using multiple tables for data entry. If I do not fill
in all entries in the form, my form record count at the bottom will not count
the entry. I will have the data in my table but I do not see it in the form.
I have set my relationship to 1 to 1 with a primary key. How do I
capture/count all records in my form?

Please Help.

Thank you
Click to expand...

WHOA. You may have things backwards.

Are you using *tables* for data entry to a *form*? If so that's backwards.
Tables store data; Forms are tools to enter data into tables, not vice versa!

Why multiple tables? What's in them?

What's the Recordsource for your form?

Why 1 to 1 relationships? In practice they are VERY rarely needed: if you're
doing Subclassing, or Superclassing, or Table based field level security, then
a one to one may be appropriate; if not - or if you don't know these terms -
it's almost surely not.

John W. Vinson [MVP]
 
Thanks John for your response. I am trying to enter the data in my form to
populate my table. My problem may be with my relationships. Example: I
have 1 well (wellInfo) that could have these curves DT,ILD,POR....).

Table1: WellInfo = API (PK), wellname, Wellnumber, Company
Table2: SonicCurve = API (PK), DT, TVT,SDT, CDT
Table3: ResCurve = API (PK), ILD, ILM,M2RX, M2R9
Table4: PorCurve = API (PK), POR, NPHI, DPHI

In a form I want to enter my well information and then if that well has a
particular curve associated with it I would like to add that data. As of now
in my form I entre all the well information and say I have only the DT curve
(under SonicCurve) and no data for ResCurve. When I get out of the form and
come back in I will not have the record in my form display for that entry but
it will be in my table....

Thanks John for your help and any suggestions.

Sean
 
Thanks John for your response. I am trying to enter the data in my form to
populate my table. My problem may be with my relationships. Example: I
have 1 well (wellInfo) that could have these curves DT,ILD,POR....).

Table1: WellInfo = API (PK), wellname, Wellnumber, Company
Table2: SonicCurve = API (PK), DT, TVT,SDT, CDT
Table3: ResCurve = API (PK), ILD, ILM,M2RX, M2R9
Table4: PorCurve = API (PK), POR, NPHI, DPHI

In a form I want to enter my well information and then if that well has a
particular curve associated with it I would like to add that data. As of now
in my form I entre all the well information and say I have only the DT curve
(under SonicCurve) and no data for ResCurve. When I get out of the form and
come back in I will not have the record in my form display for that entry but
it will be in my table....

Thanks John for your help and any suggestions.
Click to expand...

Why use four tables when one would do? Could you just include the DT, TVT,
...., DPHI fields in WellInfo? Or is this just an example and there are many
more fields?

With one table, it's trivial: just have three tab controls on the form with
textboxes for the fields for the different curves.

If you have reason (as you well may) for using "Subclassing" - each table
legitimately has one related record in either SonicCurve or ResCurve or
PorCurve (or in two or three of these), then don't base your Form on a Query
joining all four tables as you're apparently now doing. Such a join will show
you data only if there is data already in *ALL FOUR* of the tables. Instead,
use a Form based on WellInfo with three Subforms, one based on each Curve
table. Use API as the Master/Child link field for each.

If it's possible to have more than one set of SonicCurve information for a
well - say you had reason to remeasure it - then you need a one to many
relationship, rather than a one to one relationship. In that case you would
certainly want the four tables, and you would also want to use subforms.

John W. Vinson [MVP]
 
Back
Top