You want option two. The only downside in Access with this method is you can't use the define relationship tool and paint the queries. But you can still do the selects with SQL.
On Wed, Nov 19, 2008 at 8:56 PM, Scott Doc <[EMAIL PROTECTED]> wrote: > Hello wise database experts, > This is a hard thing to explain, but I'll try. I am using Access DB. I have > several different tables of people, places, articles, photos, messages, > comments, etc.. And as you would expect these tables are linked by 3rd party > tables on things such as categories etc. > 2. 4 columns. First two containing IDs, the second two with a key identifying > the TYPE of ID > ID1, ID2, typeof1, typeof2 > so example row could be: 55, 23, article, photo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3152 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
