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

  • 6 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.

    • Commenter avatarLogin to reply the answers
  • Steve
    Lv 5
    6 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.

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.