Keith Clark wrote:
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]
Keith, since you've only got 2 tables and one depends on the other, you
might as well just use the Form Wizard and use the Sub-form. Once
you've got it pretty well set up, you can Hide the Controls you like or
you can delete them completely.
You also might consider the possibility of starting some sort of text
document with the tips you discover as you go along. That's what i've
taken to doing since it also happens to me. i sometimes go a year
between having to create a new database and by then all that info is
just... history. i'm using OpenOffice and its ability to create
Bookmarks within a document so i can create a simple index at the
beginning and link to the bookmarks within the doc. Eventually this
memory thing will probably get so bad i'll forget that i created the
document, what i named it or where it's hidden -- lol !
Have a great evening! :) , fred
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
