Relationships with forms

[Scott McLean]

I have a database with 4 tables. Three of them have one
to one relationships with the main table. However I have
a form that inputs data into the tables together linking
them with a primary key. My problem however is that
everytime I type in the data, the record button in the
bottom left records all the sheets I have filled in but
if I close the form and re-open it the record in the left
does not show any record of the previously stored data.
Does anyone know how to get the record button to keep a
running list of all records or what I have done wrong in
the relationships.

 

[Tim Ferguson]

I have a database with 4 tables. Three of them have one
to one relationships with the main table.

Why? One to one relationships are very rare in good database design
(although they do have their place, for example in subtyping solutions).
What do you hope to gain by not having the fields in one table?

if I close the form and re-open it the record in the left
does not show any record of the previously stored data.

Sorry: I really don't understand what this form is trying to do. I suspect,
however, that it would be cured by getting the tables designed correctly.

B Wishes


Tim F

 

[John Vinson]

I have a database with 4 tables. Three of them have one
to one relationships with the main table. However I have
a form that inputs data into the tables together linking
them with a primary key. My problem however is that
everytime I type in the data, the record button in the
bottom left records all the sheets I have filled in but
if I close the form and re-open it the record in the left
does not show any record of the previously stored data.
Does anyone know how to get the record button to keep a
running list of all records or what I have done wrong in
the relationships.

It's not the relationships; it's the form.

It sounds like you've tried to create a monster Query linking all four
tables together and based a form on this query. That's not impossible
but it's usually not the best way! Normally one would create a Form
based on the "parent" table, with subforms for the "child" tables.

Note that one to one relationships are VERY RARELY NEEDED; if you have
four tables in one to one relationships because you need more than 255
fields, your table structures are almost certainly INCORRECT. What are
these tables? Why do you need one to one relationships at all?