database redesign

  • Thread starter Thread starter eb1mom
  • Start date Start date
E

eb1mom

On good advice from the query forum I am redesigning a
database. I had no problem getting data from old table into
new table (copy-paste). My question is about form to enter
more new information. Old data entry form brings up a new
record with 15 text boxes, cuts 1-15(these were combo boxes
with pattern # from pattern table, bound to cut #) and 1
text box for new post #. I now have one table with
"post-cut-pattern" as suggested. I would like to have new
data entry form look as close to old as possible. I don't
understand how I could get a group of fifteen new records
with new post# and cut# filled in. I created a new table
with cut positions and a query based on new table,pattern
table and cut position table. My form based on query was a
mess. Could someone suggest a good demo database close to
what I am trying to do? Thanks

Post from yesterday with more information.
Table is set up to store which pattern cuts are made to
which posts.
One record might look like this.
Field
postname: post1
cut1: pattern4
cut2: pattern5
cut3: pattern8
cut4: pattern1
cut5: pattern2
cut6: pattern11
cut7: pattern2
cut8: pattern3
cut9: pattern4
cut10: pattern4
cut11: pattern6
cut12: pattern8
cut13: pattern9
cut14: pattern10
cut15: pattern12
There are over 100 "posts" and 100 "patterns" that could be
cut in any combination on each post.

A much better design would be to split this into as many
records as
you have cuts: e.g.

Postname
Cut
Pattern

with records

Post1; 1; "Pattern4"
Post1; 2; "Pattern5"
Post1; 3; "Pattern8"
 
This may not look a whole lot like your previous form, but the simplest to
implement would be a main form with your post number and a subform based on
your post-cut-pattern table.

HTH
- Turtle
 
Thanks for the advice. I will attempt to do as you
suggested. I may be back for more help.
 
You might want to relook at your table desugn; it is still not correct! Any time
you have multiple fields in a table of the same thing (Cuts), yiyr table is not
normalized. This is the reason you are experiencing a problem. Once you set up
your tables correctly, take a look at continuous forms in the Help file to enter
the Cuts.
 
Back
Top