junction tables and subforms - my brain is fried

I am hoping someone can help me with my junction table issue. I have two
tables and a junction table already set up, and now I need to figure out the
best way to enter the information in a form/subform.

I have a "supplier" table and a "product" table. I have a "supplier_rates"
junction table with the "supplier" primary key, "product" primary key, and
fields for "price" and "price per unit". I would like to enter the data for
each supplier (ie price list) on the bottom of an existing form already
completed for supplier information (based on "supplier" table). What is the
best way to do so? I believe I need to create a subform based on the
"supplier_rates" table, but when I try this on my own I can't figure out how
to create a form that allows for multiple "products".

How can I create a subform that will allow for creation of a price list? Is
this an issue with the setup of the tables and am I missing a step? Or what
is a better alternative? Something that looks like a mini-spreadheet/table
for data entry is what I need....
--
swooley

On Fri, 2 Oct 2009 14:47:01 -0700, swooley
wrote:

I am hoping someone can help me with my junction table issue. I have two
tables and a junction table already set up, and now I need to figure out the
best way to enter the information in a form/subform.

I have a "supplier" table and a "product" table. I have a "supplier_rates"
junction table with the "supplier" primary key, "product" primary key, and
fields for "price" and "price per unit". I would like to enter the data for
each supplier (ie price list) on the bottom of an existing form already
completed for supplier information (based on "supplier" table). What is the
best way to do so? I believe I need to create a subform based on the
"supplier_rates" table, but when I try this on my own I can't figure out how
to create a form that allows for multiple "products".

How can I create a subform that will allow for creation of a price list? Is
this an issue with the setup of the tables and am I missing a step? Or what
is a better alternative? Something that looks like a mini-spreadheet/table
for data entry is what I need....

I think all you're missing is that the Subform, based on supplier_rates,
should be in "Continuous Forms" view. It would use the SupplierID as the
master/child link field (to display all that supplier's products and let you
add new ones), and would include a Combo Box based on the Products table to
add the product name; and have textboxes for the price and price per unit (if
indeed the price per unit isn't deriveable from the price...)

--

John W. Vinson [MVP]