D
dhstein
This is a little complicated. I'll try to explain as best as I can - and
what I'm looking for are just some suggestions as to how I might do this -
rather than any specific code - although if it exists - I'd be happy to see
it.
The situation is we want to allow the user to adjust inventory quantities
for products. But a product is actually a family of products - so that if
he's going to adjust widgets - we want to display all the widgets on the form.
Example:
Widget - Large Size 10
Widget - Medium Size 15
Widget - Blue and Yellow 3
Each of these rows is a record in a table - and they all share the product
code of "widget"
But there might be as few as 2 items or as many as 20
I think I want a form bound to the table but I'm not sure how to display all
the records that are "widgets". I can display one record in the form, or I
can display the entire table, but I'm not sure how to get just these items.
Also since the number varies this is another complexity. I looked at binding
the fields to a query but I'm not sure if that is the path I need. Again,
I'm just looking for an approach that I might try to work on. Thanks for any
help with this.
what I'm looking for are just some suggestions as to how I might do this -
rather than any specific code - although if it exists - I'd be happy to see
it.
The situation is we want to allow the user to adjust inventory quantities
for products. But a product is actually a family of products - so that if
he's going to adjust widgets - we want to display all the widgets on the form.
Example:
Widget - Large Size 10
Widget - Medium Size 15
Widget - Blue and Yellow 3
Each of these rows is a record in a table - and they all share the product
code of "widget"
But there might be as few as 2 items or as many as 20
I think I want a form bound to the table but I'm not sure how to display all
the records that are "widgets". I can display one record in the form, or I
can display the entire table, but I'm not sure how to get just these items.
Also since the number varies this is another complexity. I looked at binding
the fields to a query but I'm not sure if that is the path I need. Again,
I'm just looking for an approach that I might try to work on. Thanks for any
help with this.