Add new product on Orders form (Northwind)

[Cifrocco]

I'm using the Northwind sample database as a starting point to build a simple
ordering/inventory application. (Like a gazillion others have done before me,
lol.)

When I'm in the Orders form and I'm entering a product on one of the subform
lines, it won't accept a product description that isn't already in the
Products table. I would like to be able to add a new product right there,
with price information and have it update the Products table automatically.
Is this possible?

I tried going into the Relationships screen and change the 1-to-many
relationship between Products and Orders to have it Cascade Updates, but it
doesn't seem to work.

Any ideas? Many thanks.

 

[Jason]

I use the facility to open the stock table (e.g. have button at bottom of
orders to add/edit stock). The thing I haven't done yet (I have on other
forms though) is requery the orderlinessubform so the new item will show.
The disadvantage of using the orderlines form to add new item is you will be
missing a lot of the fields. I've spent a lot of time on my db not much on
orders/invoices (must get back to doing that) but a lot that replicates what
you are trying to do.