Re: FN-FORUM: Access Problems

date posted 6th August 2004 13:45

John Murphy [EMAIL REMOVED] writes:

> Hey all
>
> 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?
>
> John

Its a master-detail relationship. You need a table of suppliers with a
primary key, and another table for the items that relate to each
supplier. This table has a foreign key to the Supplier table.

Then you build the GUI.

Too obvious?

--
Jonathan