Access for web apps at all, so I have next to no experience writing
queries in Access to the degree that would be needed to accomplish what
you are trying to do. Perhaps someone else can chime in. I still say
that your best approach is to yes, rewrite the queries only after you
fix the table structure! :-)
Michael T. Tangorre
*sigh*
Well.
First problem is that I'm using Microsoft Access.
Second problem is that the casinos table has several fields that
are
meant to collect gametypes.
Blackjack,poker,slots,videoslots,tablegames I think.
Each of these right now is gathering a comma delimited list of
different
record IDs.
What needs to be done, and correct my if I am wrong, is to
create a
seperate table for each of these fields that will store the
tblcasinos.casinoid and the relevant type id, whether it is
tblblackjack.blackjackid, or tblpoker.pokerid,tblslots.slotid
etc.
So ...essentially what needs to be done is to go over this
entire
application and rewrite every query?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
