Data lost in form... But still in table... What the????

[Guest]

Hello,

Thanks in advance to anyone who answers.

Well, let me start by informing you that I don't know how to program. I
started making a database of customers and the deliveries I have made for
each one. I first made the following 5 tables: Customers, Phones,
Deliveries, Addresses and Cargo. I then made the relationships between them:

Customers One-to-many Phones
One-to-many Deliveries One-to-many Addresses
One-to-many Cargo

Since I don't even know what referential integrity is, I haven't checked
that box in the relationship window. Next I created the forms using the
forms wizard. Addresses and Cargo side by side as subforms in the Deliveries
form. Then I made the Phones form and then made it and the Deliveries form
as subforms of the Customers form. So basically, the customers are the main
table. Customers can have several phone numbers and several different
deliveries. Each delivery can have different addresses and different cargoes.

Now, to the reason for this posting. I started entering information in the
forms. When I finished the first customer, his phone number, address I
delivered to and the cargo I delivered, I closed the form. I later reopened
the form to enter more data and discovered the address information was
missing and the cargo listing. I then looked at the tables (not the forms)
and found the information there.

How can I make the information return to the Forms View? Any information
will be appreciated.

 

[Ken Snell [MVP]]

Sounds like the form's Data Entry property is set to Yes. Change it to No.

 

[Guest]

Thanks Ken,

I looked at all 5 forms. The Data Entry Property on all 5 is already set to
"no"...
Could it be something else?

 

[Rick Brandt]

Thanks Ken,

I looked at all 5 forms. The Data Entry Property on all 5 is already
set to "no"...
Could it be something else?

If the MasterLink and ChildLink properties of the subform are incorrect then
those subforms won't show the rcords that are related to the current parent
record in the main form.

That mistake "ordinarily" would have caused those foreign key values to be Null
when you created the records which would cause an error. Had you set up
referential integrity you likely would have gotten that error.