This is an "Add product" form.
The user will enter a ProductNo (catalog number), select a Product Class
(from cascading combo boxes) and then click a button to create the product.
When a product is added, a recordset (class) from a table (tblClassDetails -
fields are: ClassID, SpecID) will be cloned into another table
(tblClassProJoin - fields are ClassID, ProductID, SpecID and Value).
Obviously, ClassID and SpecID will be cloned.
The ProductID field is tricky. Product numbers are held in tblProducts. Each
Product number (the product's catalog number) will have a corresponding
ProductID which will be an autonumber field (duh). Ideally, the new product
record would be added to tblProducts and the ProductID field value would be
created. Just after, this ProductID would be added to tblClassProJoin as per
above.
The Value field from tblClassProJoin is not required for this form. It will
be manually entered later.
Any thoughts on how this can be accomplished. I was thinking of an append
query but I don't know how to get the cascading class selection as a
parameter.
Obviously, I'm a bit of a knob as far as access is concerend. _Beginning
Access 2002 VBA_ is on the way, but I thought I'd get a head start here.
Thanks for any thoughts.
Regards,
Robin