Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many relation on a form
Message
From
01/06/1998 15:22:29
 
 
To
01/06/1998 15:15:05
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00103741
Message ID:
00103748
Views:
22
I would use a grid based on an updatable view with the ISBN as a parameter. For each new book, you requery the view.

HTH

>I have a form on which I'll have two files in the data environment. A book file and an author file. An author is related to the book by an ISBN number. One book can have several authors.
>
>On the title entry form I'd like to show all the authors (lastname) for a particular title (maybe in a listbox). The user would have the ability to add/delete authors.
>
>What is the best way to implement this on a form (listbox?,grid?) How do I only show the authors that belong to that book?
Previous
Reply
Map
View

Click here to load this message in the networking platform