Hi all!

I noticed that there is one post with the similar subject but i couldn't get the necessary help from it.

Here's what i have:

Main form CargoType, and i'd like to have a subform named subPackage. I want when the used selects an item from the main from by a combobox, to view the related information abt the types of package in the subform and if there's need to enter new type just to do it, or to select one from the already used. I hope this explanation is not too complicated.

The problem arised cause i have a relation many-2-many as shown below:

tblCargoType
CargoTypeID-A#
CargoID-it's FK related tblCargo with tblCargoType
CargoType

tblPackage
PackageID-A#
Package

jnxtblCargoType_Package
CargoID-PK
PackageID -PK



One cargo type can have many kinds of package and reversible one package kind could be for many cargo types.

How could I resolve this?

Thanks in advance,
Iva