I have two tables in MS Access. First is Categories (of Products), which includes ID_category and Category_Name.
The second is Products which includes ID_Product, Name, Description and few others...and ID_Category (every Product is assign to one Category)
A want to create connection between Categories Table and Products - when the Categories Table is shown I can choose one categories (for example: TIRES with ID_Category = 2). Then next page will show all records from Product Table which ID_Category = 2. What will be the best solution?
