Newbies KenL Posted January 25, 2001 Newbies Share Posted January 25, 2001 I have a titles/authors system in which one title may have many authors and one author may have many titles. I understand the concepts of the join file and record IDs. What I want to do is to have the user create a title, then fill in the authors via a portal. I'd like to have each portal row have a drop-down value list of authors because the authors database will have contact info. I'm having problems setting an author ID to a particular title ID in the join file. I hope I explained my situation well enough. TIA. KenL Link to comment Share on other sites More sharing options...
Chuck Posted January 26, 2001 Share Posted January 26, 2001 The easiest way is going to be by allowing the relationship to create related records. When this happens, a blank portal row will appear in portals into that relationship. Then you can have a menu for the Author ID that has a value list showing the Authors' IDs and their names (since IDs would probably be useless to the user). Once you select an ID in this menu, the record should be added in the join file automatically. Chuck Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8503 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now