8 Replies Latest reply on Mar 3, 2013 5:11 PM by WataruYamazaki

    [SOLVED]About One to many relationship through dropdown

    WataruYamazaki

      Title

      [SOLVED]About One to many relationship through dropdown

      Post

           Hello Forum

           I am a total noob with DB software and currently working on a project for my highschool coursework. The goal is to make a small library database for my Japanese teacher, but I encountered a problem. I'm using FMP11 Adv on Win7.

           That is, when I tried to input a book, sometimes they have the same publisher (and author) between two books. I have join table between Bookinfo(books) and tblPublisher(publisher) with BookID(key) and PublisherID from each tables. Then on a form, I have a dropdown that will show the valuelist of all the publisher. (See the capture for the detail) 

           For the first book, it will work just fine, but when I enter another book with the same publisher, I can select the publisher from the valuelist, but it will end up entering the corresponding PublisherID number to the Publisher field. I fiddled around with it, but only thing that allowed me is to input either the corresponding PublisherID or make a duplicate record in tblPublisher with the same publisher name. I know I'm screwing up somewhere, but I have no idea where. Also, is my approach correct for what I want to do?

            

           Thanks in advance.

      %E3%82%AD%E3%83%A3%E3%83%97%E3%83%81%E3%83%A3.PNG