Fill next record based on previous

  • Thread starter Thread starter CJ
  • Start date Start date
C

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?
 
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.
 
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!

Klatuu said:
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.
Click to expand...
 
Back
Top