Relationships

[prometro]

Hi, I found one big problem in my database and i need quick help please!! huiii
At the beginning i had one big table with about 60 fields.
I was not sure if it is not so much so i parted this table to about 4 tables because of lucidity.

My question :
1) Is it possible to have in good database table with 60 fields or more - what about speed of database?
2) If i do partition to more tables, how to do the best setup of relationshios?

I did small example with 3 tables (please see in attached file)
Table1 is in relation with two others 1:1
In every relationship I check off Referential int., cascade update and delete.
Problem :
I did Form where are data from all three tables.
If i do new record and fill data to textbox (Table1) then to textbox (Table2)and to textbox (Table3) - everything is ok.
But! When i fill data only to textboxes (Table1) and (Table3), close Form, open Form again, and try to fill the last textbox (Table2), it is impossible!!!
I dont understand where is problem in relationships - or in table design....?

Only I want is to parte one big Table to more Tables but everything with the same properties like that it is only "one tabel".
Thank you for help me with it!
Jirka

 

[prometro]

Jej, I worked on it to the night, uf. But I found solution.
Problem was not in relationships but in Form.
I gived data from all three Tabs into the one Form and it was mistake.
Now I gived data to the Form from only one Tab and data from the others Tabs I gived like a SubForms. Everything is going perfect!