List Box - Item To Populate A Table

[bhipwell via AccessMonster.com]

Hello,

I have the following tables...

Product (a table of available products)
Company (a table of companies)
ProductCompany (a table identifing which products are offered by what company)


What I would like to do is have a form that...

1) Form is Company specific
2) Form has a list box of all available Products from the Products Table
3) When you double click a product, I want the selection to become a product
offered by the company

I am unsure how to do step 3. Thanks in advance!

Brandon

 

[KARL DEWEY]

Product ---
ProdID - Autonumber - primary key
Name
Size
Shape
Etc.

Company
CompID - Autonumber - primary key
Name
Addr1
Addr2
ST
Zip
Etc.


ProductCompany --
ProdCompID - Autonumber - primary key
ProdID - number - long integer - foreign key
CompID - number - long integer - foreign key
Estab - DateTime
Ceased - DateTime

Create a one-to-many relationship between Product.ProdID &
ProductCompany.ProdID and Company.CompID & ProductCompany.CompID with
referential integerity & cascade update.

Use a form/subform for Company/Products using the Company.CompID &
ProductCompany.CompID as Master/Child links. In the subform have a combo to
select products.