FORMS

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
 
J

Jeanette Cunningham

Hi,
it sounds as though the relationship 1 to 1 is causing the problems.
Can you post back with some details about your tables, here is an example of
the info that would help us to help you.

Name of table
Name of primary key field
Name of another important field in this table

Do the above process for all the tables that are used for the form with the
problem.

Jeanette Cunningham
 
S

skk

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

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 but it will be in
my table....

Thanks Jeanette for your help and any suggestions.

Sean
 
J

Jeanette Cunningham

Yes,
the table setup is causing the problem with the form.
Before I make any suggestions, could you explain a little about sonic curve
and res curve fit with a well.
can a well have both a sonic curve and a res curve? or can a well only have
either a sonic curve or a res curve or no curve?
with the fields in table sonic curve do you need to fill in the dt, tvt, sdt
and cdt for each well that has a sonic curve? and similar for res curve?

Jeanette Cunningham
 
S

skk

Thanks again Jeanette. For any type of curve I will have a well but I could
have a well with no curve. A well can have both sonic curve and a res surve
in the same well. A well can also have only a sonic curve and no res curve
or have res curve and no sonic curve. I will have to fill in each curve name
for a well.
Ex1. A well has a DT curve
I want to fill in the well info and under the sonic curve fill in DT

Ex2. A well has a DT and ILD cuves
I want to fill in the well info and under the sonic curve fill il DT and
under the res curve fill in the ILD curve.

Thanks so much for your help!
 
J

Jeanette Cunningham

2 important questions that impact on how many tables for this database:
Will a well ever have more than 1 Sonic curve, or more than 1 ResCurve or
more than 1 PorCurve?
Will a well ever have more than 1 company?
If the answer to both questions is no, put all the details in the same
table.
tblWells .
API > Primary Key
A single field for each of
Well name
Well No
Company
DT
TVT
SDT
CDT
ILD
ILM
etc

For any of the above fields that are text data type, I usually set the
property called Allow Zero Length to No.
For any of the above fields that are number data type, I always clear any
zero from the Default Value property.

Points to consider:
Will you want to search for all wells that have a sonic curve? Or all wells
with both a Res curve and a Por Curve? for example?
If a well has a sonic curve, will you always fill in a value for DT?
If a well has a res curve, will you always fill in a value for ILD?
If a well has a por curve, will you always fill in a value for POR?

Create a form for entering well details
Group the text boxes for sonic curve together and put a box around all 4
txtboxes and a label saying Sonic curve
Similar for the other 2 curves
Open the form in design view
On the data tab set Allow Additions to yes and Data Entry to No

Jeanette Cunningham
 
S

skk

Jeanette, I can have many sonic curve types for one well.
Ex. Well 1 could have curves DT, TVT, ILD (sonic, sonic, res)
Well2 could have DT (sonic) only
Well3 could have ILD, ILM, M2RX (res, res, res) only

In my form, if I do not fill in at least one entry for evry field then at
the bottom of my form (record:) I will not get all entries.

Thanks Jeanette
 
J

Jeanette Cunningham

Hi,
Sorry it is taking me a while to understand about wells and curve types.
This is the most important stage for doing a database. If we get this bit
right it will all be fairly easy from here on, but if we get it wrong, it
will work for a while then you will have to go back and redo the whole
setup. I had a bit of a browse on the internet for sonic and res curves and
these is a multitude of curve types.

Here is how I understand what you want to do - please correct me if I am
wrong.
The main form has a text box where you can type in the number, name and
company for the well.
On the form there is a way to record all the different types of curves for
that well
For example:
--a checkbox for each type of curve
--a list showing all the curve types and you can select as many curve types
as you wish
--any curve type can only be selected once only
--with each curve type there is no other information about the curve type
that you want to keep in the database
--later on you may want to go back to a particular well and change which
curve types it has.
--you will want to print a report showing all the different types of curve
for each well
--you may want to print a report showing all the wells with a particular
curve type


Jeanette Cunningham
 
Top