Newbies gregory Liegey Posted February 17, 2006 Newbies Posted February 17, 2006 (edited) Hello, I have a database of individual shots in a film. As the shots are worked on by artists, I log comments to the shots in a comment field under each shot. I'd like to do a Find which yields a list of the shots with only the latest comment for each shot. Searching by date range doesn't work as some shots receive multiple comments per day... Any ideas? (and/or any ideas where to look for info on this sort of thing in the future the FM help pages/manual don't seem comprehensive based on some of the other info I've seen posted here?) Thanks, -Greg Edited February 17, 2006 by Guest
Genx Posted February 18, 2006 Posted February 18, 2006 ... ... im not really understanding how your file is set up so ill make a few assumptions here... firstly im assuming that your comments are in a related table... secondly, im assuming you want this for a report or something...though you could just as easily throw the fields on a layout anyway.. in define database, under relationships tab... double click the relationship between your two Table Occurances i.e. Shots <--> Comments... the relationships window comes up... under the side thats relevent to the comments TO.. click sort, and specify a field you should have created which is a timestamp which autoenters on creation... ... anyway, then goto your report or layout... and just put the related comments fields on there without a portal and it will display the most recently created comment for the film shot... ... if this doesnt help or your still confused, give us a bit more information and we'll see if we can help... genx
Recommended Posts
This topic is 6869 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