Re: 1 table - 2 forms
- From: lyle <lyle.fairfield@xxxxxxxxx>
- Date: Sun, 13 Jan 2008 08:35:35 -0800 (PST)
On Jan 12, 2:06 pm, mcgrat...@xxxxxxxxx wrote:
Hi,
A customer has a table with greater than 30 columns (scientific
readings). The form used to input the data is very difficult to use
and I'd like to ask the group:-
(1) Can a main form call a sub-form that allows input of data
(into the same table as the main form) and then returns to the main
form?
(2) Could the form be split in any way so half the input fields
are available, then the operator can move to the other half?
The customer cannot split the columns in the table into two tables.
Any suggestions greatfully received.
Michael
All Data are strings.
All DataBases are vertical.
Horizontal Databases are not databases. They are toys.
Customers don't have tables. They have needs. We meet them. When we
use good database design we have a good chance of meeting them well. A
Scientific Reading is a Scientific Reading. Unless there is much more
to your story, the thirty columns should be one column and we should
edit the data with a form-subform combination based on a Main Table,
Child Table configuration.
Such a design is scaleable, easliy analyzed and likely to operate
flawlessly. Thirty columns is nonsense.
.
- References:
- 1 table - 2 forms
- From: mcgrathml
- 1 table - 2 forms
- Prev by Date: Re: 1 table - 2 forms
- Next by Date: Re: Access2003 + CDO + TO: (how do I pull TO: list from table)
- Previous by thread: Re: 1 table - 2 forms
- Next by thread: Re: 1 table - 2 forms
- Index(es):
Relevant Pages
|
