I am currently building a dvd movie database and i have a field for actors called " Also Featured In" which is a memo field. For example lets say that Sarah James was in Holly Mayfield, The Outfield, and Midnight Runner but I only have the video for Midnight Runner even though I have all three movies listed in the "Also Featured In" field. What I want to do is create some type of link from the Midnight Runner entry in the the "Also Featured In" field and have a new window open displaying the information about Midnight Runner.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reference to another record inside a memo field
- Thread starter darkmage1
- Start date
TheAceMan1
Programmer
How are ya ChaoticEmpire . . . . .
[purple]You can't make selections in a memo field! . . . forget it![/purple]
What you need is an [blue]Also Featured In[/blue] [purple]table[/purple] somehow related to the actors. If you can accomplish this, a [blue]combobox[/blue] or [blue]listbox[/blue] that automatically updates per actor would do the trick . . . .
See Ya! . . . . . .
[purple]You can't make selections in a memo field! . . . forget it![/purple]
What you need is an [blue]Also Featured In[/blue] [purple]table[/purple] somehow related to the actors. If you can accomplish this, a [blue]combobox[/blue] or [blue]listbox[/blue] that automatically updates per actor would do the trick . . . .
- Status
