Fill next record based on previous

[CJ]

Hi Groupies.

I'm using A2K7

I have an inventory database. Things are working fine except for a few of
our inventory items. These few items are considered "blended" which means
that they are an item that is made up of other items from our inventory.
When I choose a blended item, I also need it's individual components to show
up as separate records.

For example:

Quantity Item
1 Bacon, Lettuce and Tomato Sandwich
2 pieces of bread
3 pieces of bacon
2 lettuce
3 tomato

So, the BLT is the blended item, the other things are component items. I
just want to enter the BLT and everything else should pop into place.

Does anybody have any idea how to make this happen? Is it possible?

 

[Guest]

What you have is normally known as Kit inventory.
To show the components of a kit, you will need a subform and a query to use
as the subform's record source that will return the kit's component records.

 

[CJ]

Hi, thanks for popping in.

The problem that I have in this case is that not all of my products are
blended, only about 5 of them.
I guess I would have to make it so that the subform only shows up and fills
in when a blended item is selected in the main form.

Nothing a little more....elegant and (let's be honest) less labour
intensive, eh? <g>

So, if your short answer is "No", then how am I going to get all of those
component items to show in the sub?
If somebody chooses 3 different blended products, then I need all of the
components to appear.
I can picture what you have suggested in my head but how would the event
code work?

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

What you have is normally known as Kit inventory.
To show the components of a kit, you will need a subform and a query to
use
as the subform's record source that will return the kit's component
records.