in ms access, how do i link 2 tables by clicking buttons/link on one table?

for example, i click button on one table, it will direct me to another table,

i want to use this because i'm selling things on ebay, i want to click on customer's name, and it will direct me to a table to show what product the customer has purchase.

thanks for the replies

2 Answers

Relevance
  • 5 years ago
    Favorite Answer

    rather that learning a bunch of stuff about relational databases, it might be easier to download a template that already does what you want and study it to modify it for your needs if necessary.

    http://office.microsoft.com/en-us/templates/order-...

  • Steve
    Lv 5
    5 years ago

    There are a couple of ways. One way is with a form/sub form. The main form is linked to Customer, the sub form to Orders. Microsoft has a template database, Northwind Trader's I think, that has this functionality built in.

Still have questions? Get your answers by asking now.