Re: Form problem

> 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 <c.liles@...> 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: c.liles@...
>> Clifton R. Liles    "Software to the Stars"    lilescr@...
>> Pearland, TX 77581   c.r.liles@...  c.liles@...
>> - 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: users-unsubscribe@...
>> For additional commands, e-mail: users-help@...
>>
>>
>>    
>
>
>
>