Fill next record based on previous

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CJ - 18 Sep 2007 16:16 GMT

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?

Signature

Thanks for taking the time!

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

Reply to this Message

Klatuu - 18 Sep 2007 19:32 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> Hi Groupies.
>
[quoted text clipped - 19 lines]
>
> Does anybody have any idea how to make this happen? Is it possible?

Reply to this Message

CJ - 18 Sep 2007 20:41 GMT

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?

Signature

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
[quoted text clipped - 26 lines]
>>
>> Does anybody have any idea how to make this happen? Is it possible?

Reply to this Message