On Thu, 2009-10-01 at 12:55 -0400, Keith Clark wrote: > > >>>> I have two tables. > > >>>> > > >>>> Table1 > > >>>> > > >>>> ProductID INT Primary Key > > >>>> ProductName Text > > >>>> ProductCategory INT > > >>>> > > >>>> Table2 > > >>>> > > >>>> ProductCategoryID INT Primary Key > > >>>> CategoryName Text > > >>>> CategoryDescription Text > > Ok, I have solved my original problem but now I'm curious about one more > thing. If I have a list box to choose which entry in Table2 to use in > Table1, but I want to be able to add a new entry in Table2 on the same > form and use that entry. Is this possible? > > Keith
Ok, I'm part way there. I can have an in-dependant Table2 on my main form and display all the tables contents, but I cannot add a record to it. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
