I have a project log in excel and what my company calls a complex design
information sheet. What I want to do is combine the two with one form but be
ablet view the information seperately.
The first mental leap to make is:
Forms ARE NOT DATA.
A Form is just a window, a way of viewing data.
When you're building a database, the first thing to do is to *forget
about* forms, and how the data will be displayed; that's secondary.
Instead, identify the real-life things, persons, or events of
importance to the application - the "entities". A Project would
clearly be an entity; I'd guess you'll need a table to contain the
people working on the project, perhaps a table of goals, perhaps a
table of project checkpoints: I don't know your business model, so I
don't know what tables there will be, other than that there will be at
least a few other tables.
Once you have the LOGICAL structure of the data, you can build a Table
for each type of entity.
*THEN* you can start thinking about using Forms to combine and display
that information onscreen, or Reports to print the information to
paper. These Forms and Reports would typically draw information from
multiple tables, using Queries, Subforms, Combo Boxes and the other
tools that Access provides.
John W. Vinson[MVP]
