Alexandro Colorado wrote:
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]
Hi Alexandro
Yes, I too have Andrew Pitonyak's AndrewBase and have not completely
read it. I have looked through it and have not found what I am looking
for, or at least I did not recognize it. I'll keep looking, but I was
hopping for a few suggestions or hints.
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]
