Hello
Usually I "Google" the problems, but I could not find key words for my question.
I was told that if I have data in this shape:
Number ¦ Test1 ¦ Test2 ¦ Test3
------------------------------------
000001 ¦ Pos ¦ Neg ¦ Pos
000002 ¦ Pos ¦ Pos ¦ Neg
It is always better to make table in following way:
Number ¦ Test ¦ Result
---------------------------
000001 ¦ Test1 ¦ Pos
000001 ¦ Test2 ¦ Neg
000001 ¦ Test3 ¦ Pos
000002 ¦ Test1 ¦ Pos
000002 ¦ Test2 ¦ Pos
000002 ¦ Test3 ¦ Neg
All is fine, until I decide to make my form, which I want to look as follows:
Record1
-----------------------
Record2
-----------------------
Naturally, I put [Number] in "One" table, [Test] and [Result] in "many" table and made one-to-many relationship, but when it comes to subform, it is always datasheet format and [Test] must be entered for each record, while I want that it is Single Form with Test1, Test2, Test 3 pre-entered.
Basically I need the form to look like as if it was created from the first (wrong) table above.
Is it possible?
Usually I "Google" the problems, but I could not find key words for my question.
I was told that if I have data in this shape:
Number ¦ Test1 ¦ Test2 ¦ Test3
------------------------------------
000001 ¦ Pos ¦ Neg ¦ Pos
000002 ¦ Pos ¦ Pos ¦ Neg
It is always better to make table in following way:
Number ¦ Test ¦ Result
---------------------------
000001 ¦ Test1 ¦ Pos
000001 ¦ Test2 ¦ Neg
000001 ¦ Test3 ¦ Pos
000002 ¦ Test1 ¦ Pos
000002 ¦ Test2 ¦ Pos
000002 ¦ Test3 ¦ Neg
All is fine, until I decide to make my form, which I want to look as follows:
Record1
-----------------------
¦ Number: 000001
¦ Test1: Pos
¦ Test2: Neg
¦ Test3: Pos
-----------------------¦ Test1: Pos
¦ Test2: Neg
¦ Test3: Pos
Record2
-----------------------
¦ Number: 000002
¦ Test1: Pos
¦ Test2: Pos
¦ Test3: Neg
--------------------------¦ Test1: Pos
¦ Test2: Pos
¦ Test3: Neg
Naturally, I put [Number] in "One" table, [Test] and [Result] in "many" table and made one-to-many relationship, but when it comes to subform, it is always datasheet format and [Test] must be entered for each record, while I want that it is Single Form with Test1, Test2, Test 3 pre-entered.
Basically I need the form to look like as if it was created from the first (wrong) table above.
Is it possible?