Andrew Pitonyak toucnh on other things beside the SQL and go into using forms. I havent read it thoroughly but I hope it helps.
http://www.pitonyak.org/database/ On Sun, May 31, 2009 at 8:33 PM, Clifton Liles <[email protected]> wrote: > Hi All > Sorry about the weak subject, but I don't know what to call it. > The problem: > I have a table of DVDs and a table of genres. One of the items in the DVD > table is genre. The table of genres has an ID, genre ( MYST, HIS, ACT, > SIFI, ...), and a name ( Mystery, Historical, Action, Science Fiction, ...) > . > I have a form called Input that I use to enter new DVDs. I can also use this > form to view DVDs. It has a Genre input box. What I would like to do is: > If the current 'genre' "IS EMPTY" THEN display the list genres from the > genre table, showing the full name and when selected enter the genre in the > DVD genre table. ELSE show the current entry. OK this is somewhat > confusing. > If DVD_genre is not empty show that. IF it is empty the show a selection > list from the GenreTable. Show the full name and insert the abbreviation in > the DVD_Table. > > I thought I use BASIC but all I see in the form editor is SQL and some > others I don't think will work ( I could be wrong). > Any thought and or suggestions would be appreciated. Thanks > Cliff > > -- > mailto: [email protected] > Clifton R. Liles "Software to the Stars" [email protected] > Pearland, TX 77581 [email protected] [email protected] > - Speaking for myself! Standard disclaimer applies. - > This address may *not* be used for unsolicited mailings. > Failure is not an option. It comes bundled with your Microsoft products. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Alexandro Colorado OpenOffice.org Español IM: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
