Re: FN-FORUM: Access Problems

date posted 6th August 2004 13:22

John Murphy wrote:
> I'm building an application in Access to keep track of products I have
> cost and where they come from now I want to be able to do this....

> Instead of typing in the same supplier, url and number in each time

> I want to be able to pick the Supplier from a drop down and it adds the
> URL and Contact number in the valid fields. Any ideas?

Yes, buy a copy of Act or Maximizer, it'll save you ages ;)

If you really want to do it in Access, go get a book on general RDBMS
theory and practice, plus one on how to avoid all the common signs of
a crap Access database.

In the short term:

- you need a Supplier's table with the supplier info in
- you need a Product's table to hold product info
- the Product table should contain a field SupplierID that is
a reference to the ID field in the Supplier's table
- you may well (probably will) need some additional tables in order
to get all of the above down to 3NF

On the form where you add in a new Product, drop a combo and make it
look up again Supplier ID.

Cheers,

Pete
--
Peter Croft
PC Associates