access beginner here - asking for help

[Guest]

Hello,

I'm an Access beginner and i'm facing the following problem:

I have a three tables like:

1) PRODUCT( PRODUCT_ID, PRODUCT_NAME )

2) MANUFACTURERS( MANUFACTURER_ID, MANUFACTURER_ADDRESS)

and a third table in which i want to store relationships like 1 PRODUCT ---
N
MANUFACTURERS:

3) PROD_MANUF( RELATION_ID, PRODUCT_ID, MANUFACTURER_ID )


The problem that I have is that I want to create a From which would contain a
Combo List with Multiple selection, from which I will select all
manufacturers for a given product.

The problem is that I don't know how to update the PROD_MANUF table to be in
concordance with the selection in the combo list.

Any tips, please?

 

[Steve Schapel]

Ilya,

From what you have described, this is what I am envisaging:

A form based on the Product table.

On that form, a subform, in continuous view, based on the Prod_Manuf table.

On that subform, the Product_ID is hidden (because it is managed via the
Link Master Fields / Link Child Fields properties of the subform.

And on the subform, a Combobox, bound to the Manufacturer_ID field, with
its Row Source set as the Manufacturers table.
(You can adjust the properties of the combobox so that it is the
Manufacturer_ID that is the bound column, but the Manufacturer_Name that
is shown on the form.)

So that way, you go to the record on the Products form for the Product
in question, and just enter the Manufacturers of that product, as many
as you need, via the combobox on the subform.