Multiple Items; layout stacked instead of tabular

[Haagen Waade]

We are trying to make a from where it is possible to register more
than 1 record. The Multiple Item Form solve that.
But we would like to have the (one) record listed as a column, and not
as a row (as the Multiple Item Form does).
We tried to change the layout in design view, but that only gave us
more pages to scroll down in.

What the Multiple Item From gives us:

Record x x x x x x x x x
Record y y y y y y y y y
Record z z z z z z z z z


What we want:

Record x y z
Record x y z
Record x y z
Record x y z
etc.

Is there any possibility to do this?

 

[Clifford Bass]

Hi Haagen,

What you are describing is a standard parent table and child table,
along with a form and a subform.

tblParent
ParentID (primary key)
other fields

tblChild
ParentID (primary
ChildID key)
other fields

This allows the child table to have multiple rows for each parent row.
Then you design a couple of forms, a main one that uses the parent table and
a subform that uses the child table. Do a search for "Guide to table
relationships" and "Create a form that contains a subform", with the quotes
in each case, in Access's online help to get more information.

Hope this helps,

Clifford Bass

 

[KARL DEWEY]

Are you saying your data is like this --
Last First Hire DOB
Jones Bill 1/1/1975 2/2/1955
Harris Rex 2/3/1999 3/3/1966
etc
and you want the form to show this --
Last Jones Harris etc
First Bill Rex
Hire 1/1/1975 2/3/1999
DOB 2/3/1955 3/3/1966

 

[Haagen Waade]

Are you saying your data is like this --
Last    First Hire         DOB
Jones Bill     1/1/1975 2/2/1955
Harris Rex    2/3/1999 3/3/1966
etc
and you want the form to show this --
Last    Jones           Harris        etc
First    Bill              Rex
Hire     1/1/1975    2/3/1999  
DOB    2/3/1955    3/3/1966

Yes, that is exactly what we want the form to look like!

 

[KARL DEWEY]

If you have a numerical primary key that has no gaps this might do it for
you.
It has 5 fields across --
SELECT [Table A].field1, [Table A_1].field1, [Table A_2].field1, [Table
A_3].field1, [Table A_4].field1, [Table A].field2, [Table A_1].field2, [Table
A_2].field2, [Table A_3].field2, [Table A_4].field2, [Table A].Facility,
[Table A_1].Facility, [Table A_2].Facility, [Table A_3].Facility, [Table
A_4].Facility, [Table A].Zone, [Table A_1].Zone, [Table A_2].Zone, [Table
A_3].Zone, [Table A_4].Zone
FROM [Table A], [Table A] AS [Table A_1], [Table A] AS [Table A_2], [Table
A] AS [Table A_3], [Table A] AS [Table A_4]
WHERE ((([Table A_1].PK)=[Table A].[PK]+1) AND (([Table A_2].PK)=[Table
A_1].[PK]+1) AND (([Table A_3].PK)=[Table A_2].[PK]+1) AND (([Table
A_4].PK)=[Table A_3].[PK]+1))
ORDER BY [Table A_1].PK;