I have to make program for Videoshop. I use Visual Basic and Access. Database has tables: members, films, maintable. In members table are stored id, name, address etc. of every member, in films are stored id, name, number of copies etc. of tapes/dvd, in maintable are stored other datas: id and name of member, id and name of tape/dvd, first date (when somebody take tape/dvd). Here is a problem. I can make this but i have there is problem if some member takes more tapes/dvds. Example: some member takes 4 tapes. how can I realise this. Please I am total newbie.
Sorry for bad english.