by RUg » Sat, 09 Jul 2005 03:43:02
Thank you for your reply. However I am more than likely too frustrated with
this project now to fully grasp what your saying. The macro and data entry
for the 2nd form is simple enough.
I guess I just dont understand this "Style: [forms]![myform]![style]" to put
in the query. Of course I renamed "myform", However its not accompishing
much of anything, more than likely because I'm not doing it right. Let me
explain in a bit more detail if I can.
1st table:
Columns: Style, SAM, Step, Description
2nd Table:
Columns: Group Number, QTY, Color, Size, and Thread
Basically The 1st table will have a few hundred styles in it. Style could
have more than one of the same number, and Step will be numbered as a "step"
for each of the Style Numbers, SAM, and Description will vary in each. For
example:
Table 1:
Style Number SAM Step Description
503 $0.91 1 SEW 2-PC COLLAR W/PELLON
503 $0.15 2 TRIM CORNER
503 $0.51 3 TURN & PRESS COLLAR (AAMCO)
503 $2.94 4 TOPSTITCH COLLAR 1/4
503 $0.41 5 PRES COLLAR STAND
These values are pretty much set until something changes months down the road.
There will be more than 503 for the style number, around 300 or so different
ones in fact, with 12-40 Steps in Each.
Table 2:
Group Number Quantity Size Thread Thread
6007 30 M WHT WHT-32001
This is only one record as all columns need to change every time they print
some labels.
As I was saying. I just cant seem to get the user to be able run a report
that will ask him/her for the info from table 2, at the same time, query the
style they want from the first table.
Basically all of the information will go into a sheet of special label
paper, each "step" of a style being printed on a separate ticket (which is
why I made that portion a separate table), and the 2nd table is repeated
information throughout all of the tickets.
Im trying to make this as user friendly as possible, else there are a few
other ways I can go about it. Basically it needs to be click and go for the
most part unless entering in new or fixing some of the Style Steps.
As always, any input is greatly appreciated or even another way of doing it.
My brain is fried at this point. Hope I'm not confusing anyone.