Vendor Customer Product Cross-Reference?

I'm totally new at this, and literally just installed Access 2003.

As in the Subject, what I'd like to get out of Access is a simple form with
three choices to click on: Products, Vendors, and Customers.

Clicking on an item in Products would bring up side by side lists of the
Vendors who sell it and the Customers who buy it. Likewise clicking on a
name in Vendors would bring up the products they carry and clicking on a
name in Customers brings up a list of products they have bought.

The data right now is in Quickbooks Premier and that can be exported to
Excel which Access can import.

Is this even possible? What skill level and learning curve am I looking at?

Thanks, Brent


.

Relevant Pages

  • Customer List Categorized
    ... I am setting up my customer list and I need to identify which vendors each customer buys from. ... I want to eventually be able to sort this list according to the vendors that the customers buy from for specific calling lists for my sales staff. ...
    (microsoft.public.excel.newusers)
  • drop downs in billing form
    ... I'm trying to create a billing form that contains drop ... down lists for both my customers and my vendors. ...
    (microsoft.public.access.forms)
  • Re: They will protect me (wont they?)
    ... is an important aspect of their business because their customers don't ... from a security technology vendor "We don't perform regular penetration ... service why would it be the vendors obligation. ... I am not talking strictly about security service providers. ...
    (Pen-Test)
  • Re: Attitude to defects
    ... By paying attention to these lists when scheduling ... Developers don't need to distinguish though: ... Don't waste effort on separating the sheep and goats, ... Customers don't care _why_ something doesn't work, ...
    (comp.software.testing)
  • Re: OT Advice on good forth coding
    ... would be absurd for Forth vendors to follow KISS as far as it goes. ... has necessarily involved a significant increase in complexity, ... with hoots of derision from most potential customers. ...
    (comp.lang.forth)
Loading