By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,929 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,929 IT Pros & Developers. It's quick & easy.

Nested forms, three deep to create Excel-like tables???

P: n/a
NA
Is it possible to have adjustable tables (not Access tables per se) but
those in Ms Word or Excel based on nexted forms three deep? In other words,
if I have a main form, Repair History, both the row and columns would grow
accordingly.
Column Heading: Parts
Row Heading: Repair Description

In this case, I may only know 25% of the parts when creating the table after
which, I would like the user to be able to add both the type of parts as
well as the repair description. So, something like this
***Day 15: New User
Customer info
...
...
...
...

Repair History

Washers Gaskets
Solder
1) Bathroom Sink Leak Repair [SS - s14] [natural ruber -size 00] [
Acid Core - 5feet]
2) Master Shower Repair [Bronze - s20]
***Day 200
Customer info
...
...
...
...

Repair History
Washers
Gaskets Solder Caulk
1) Bathroom Sink Leak Repair [SS - s14] [natural ruber -size 00] [
Acid Core - 5feet]
2) Master Shower Repair [Bronze - s20]
3) Tub Repair
[silicone- 1 tube]

In this case, the users would merely add a column heading 'Caulk', which,
presumably, would be an additional record in the parent table (repair parts)
to the workorders table. This is necessary because the database design
knows little about plumbing and the plumbers know nothing about database
design. I would assume that this could be achieved by nesting the three
forms from the three respective tables three deep. However, I can't seem to
get it to work.

Can Access allow such "tables" to expand both horizontally and vertically?
Note that I do not want to use combo boxes.


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"NA" <NA@NA.COM> wrote in message news:<40**********************@news.rcn.com>...
Is it possible to have adjustable tables (not Access tables per se) but
those in Ms Word or Excel based on nexted forms three deep? In other words,
if I have a main form, Repair History, both the row and columns would grow
accordingly.
<SNIP>
Can Access allow such "tables" to expand both horizontally and vertically?
Note that I do not want to use combo boxes.


Sounds like a fundamental misunderstanding of database design. Excel
and Access are VERY different. Tables in Access are not really meant
to be adjustable - well, not after you've delivered your solution, say
as an MDE. If you want the users to be able to add fields at runtime,
you're going to make a serious mess of your database. You need to
figure out what information you need to store about each "thing" up
front. You can hide fields on your form, but you really shouldn't let
your users muck with your table design. It'll be impossible to keep
your database working.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.