How is your layout designed? The "boxes" in your screen capture are called table occurrences.
On which table occurrence is the layout based? (What is selected in Show Records From in Layout Setup...?)
What objects have you added to this layout for selecting your books? Do you use a portal to tblPubBo 2?
Thank you for the reply, PhilModJunk!
The layout is based on Bookinfo table(you mean "display records from..." on Layout setting, right?). The layout has portals displaying a value list, as a pulldown which is set to show Publishername field from tblPublisher. (see the capture). So I'm guessing I have to use portal to the "joining tables"?
Also I have webviewer that will do a search on Google Books based on ISBN field on Bookinfo. And some buttons for navigation(next record, previous record, back, reload and forward for webviewer ), and one button for creating new record on Bookinfo(sorry, all the labels are in Japanese).
Everything else is working except the pulldowns.
Yes, you need a portal to the join table. Otherwise, there is no way to link a book to multiple publishiers.
Hmmmm, so I changed the portal to Publisher field on tblPubBo2. But then I get my Publisher's name into tblPubBo2's Publisher field when I enter new book and get no record on tblPublisher...
If I make a record for the publisher on the tblPublisher before the book entry, I can choose it from the dropdown list, but on the layout, it will display the ID for the publisher after choosing, so just a number. It's preferrable to have its name, not the number.....
Sorry to be asking lots of stuff...
In your screen shot, I don't see a portal, only individual fields. You need a portal so that you can list multiple records for each publisher by listing records in the Join table.
You may find this demo file on many to many relationships helpful: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7
Aha! that's the problem.....I somehow thought the actual portal was just a aesthetic "box" and deleted it every time I made a portal.
The tutorial file was really helpful making me understand this thing. Thank you very much.
So I created 1 by 1 portals for each fields, and made one pulldown for Publisher field on tblPubBo2, and also to display name, I made Publishername field from tblPublisher next to it. I did the same to other two fields(Author and Genre). Somehow the Genre fields managed to work, both selecting existing Genre from the pulldown and making a new genre from the edit box next to it. However, other two(Author and Publisher) doesn't let me click on the edit box. Which setting should I change?
Another question. Is it okay for me to mention your (user)name in my project report?
You need a single portal with multiple rows and a scroll bar. Put all your fields in the portal row.
I don't object if you use my forum name in your report.