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
- BlackenedLv 65 years agoFavorite 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.
- SteveLv 55 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.