You have a good start on a product specification for your prospective
application.  But your request for pointers to implement it is too
broad to be addressable except in similarly broad terms.

To do it using Access you'll have to learn Access or rent or buy the
skill from someone who already knows it.

You didn't specify directly but it seems implicit that you already
have some machine readable information from the current process.  It
it's at all reasonable to do so, use the existing information in its
current form.  Either link to that information or import it as best
meets the needs of your application.

You have to supply the missing details for all of the things that
don't yet exist to get you from where you are to where you want to be.

HTH

Hi Matt

The simplest setup would be to have three tables.  It sounds like you
already have two of them, but you don't mention that they have primary keys,
and these are crucial to the design.  A primary key uniquely identifies a
record in that table and is used to link that record to "foreign keys" in
other tables.  Your Suppliers and Products tables both require primary keys.
If you don't have a "natural" primary key (such as ProductCode or
SupplierNumber) then just add an AutoNumber field to those tables.

So, you will have three tables as follows:

Suppliers:
   SupplierID (primary key)
   SupplierName
   ContactName
   ... etc

Products:
   ProductID (primary key)
   ProductName
   ... etc
   (note that the price does NOT go here)

SupplierProductPrices:
   SupplierID (foreign key to Suppliers.SupplierID)
   ProductID (foreign key to Products.ProductID)
   CurrentPrice
   (SupplierID and ProductID should form a composite two-field primary key
to prevent duplicate records for the same supplier/product pair)

Then you should use the relationships window to create relationships between
the two SupplierID fields (one-to-many) and the two ProductID fields
(one-to-many).

For maintenance, you can create a subform based on the SPP table showing a
combo box for the product and a textbox for the price.  Add this subform to
your Suppliers form and it will list all the products sold by that supplier,
with their prices.  You can easily update this with new prices when you get
a new pricelist from a given supplier.

Similarly, add a subform to your Products form, listing all the suppliers
for a product with their prices.

The minimum current price and matching SupplierID for a given product can
then be ascertained by a simple query:

Select top 1 SupplierID, CurrentPrice from SupplierProductPrices
   where ProductID=<some ProductID> order by CurrentPrice