I keep having the same issues that I always have to stumble upon the solution.
I have two tables. Table1 ProductID INT Primary Key ProductName Text ProductCategory INT Table2 ProductCategoryID INT Primary Key CategoryName Text CategoryDescription Text Now, I want to create a form to enter date into the first table, Table1. I want to link ProductCategory from Table1 to ProductCategoryID from Table2, but I just want to show the user the CategoryName from Table2. I'm never sure how I do this and I usually just keep poking away until I stumble upon it and never learn anything. Any help would be appreciated. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
