I have a movie and music database that have evolved into larger than expected size. Recently I reorganized and added an instance table to both as I have acquired multiple copies of things... DVD, VHS, ... ALBUM, TAPE, CD, M3 and so on. I also keep a table of music artists with bio and photo , albums with photo & info. Occasionally artist table, the photo field gets corrupted somehow two records will contain the same photo... ??? of course one being wrong then... I have considered making a separate table for the photo's to make searches views and forms quicker to develop. For example, I did this in music making a separate table for lyrics so multiple songs can share the same lyrics and the majority of the music instances (that have no lyrics) can point to a memo field that reports 'no lyics available'. In a photo table I could make an image 'NO PHOTO AVAILABLE' in the table for the many instances when the field has no data. If you follow what I'm doing, am I on the right road or is there a better way. Gary the grateful rookie
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f98ba881f9ce41989d08fafac61fa...@livingroom ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
