AKSHUN

This is perfect. I just tested this out and with the use of an iterator, I can get every value in the list automatically.

I need to perform repetitive finds. Basically, it's like this. I need to perform finds based upon the contents of a value list. The number of items in that list is going to be subject to change. Currently there are 10 items, but that number will almost certainly increase and I can't know in advance what the newly added items will be. I need to perform a find and on several iterations of the find I need to set a field to (Item 1 of value list), after the search has been completed several times I need to do similar searches based on (Item 2 of value list) and so on. I need to know if there is a method for accessing the Nth item in a value list via scriptmaker. Does anyone have any idea?

I'm trying to create a many to many relationship with keys that are calculated values. I have a table that contains a fair number of fields that includes things like times, dates, and ID numbers. I need to define fields that will keep a summary of things like the total of a specific record in a given month and year. So my relationship is set up like this. Relationship_1:: Table_Instance_1 Table_Instance_2 YearOfDate = YearOfDate MonthOfDate = MonthOfDate ID = ID The YearOfDate and MonthOfDate fields are calculations based on the date of another field. YearOfDate is defined as year(job_date) MonthOfDate is defines as month(job_date) What I need to do is define a field so that it will automatically total the values in another field for an entire month. If I create a definition like this "sum(Relationship_1::Field)" even though the field in question has a lot of data in it, there is nothing totalled by the field. Do relationships based on calculations just not work?

Thank you, that gives me a much better idea of what I need to do to make my project work.

I have an idea of how a join table is supposed to work, I just can't seem to make one work properly. Does anyone have a simple FM7 file that demonstrates how a join table is supposed to work?

I am running FM Pro 7 in Windows XP. I have recently encountered a problem. The ctl+shift+d shortcut no longer brings up the define database window. I can still select it from the menu, but I can't bring it up with the key combination. Has anyone else encountered and fixed this?

Thanks for the heads up. I am having problems with getting relevant search results for join tables. Do you have any suggestions on what my search parameters should be?

IMDB was my inspiration for the project. Basically I have a friend who is a REAL movie buff. His personal collection is as large as many smaller video rental outfits. I wanted to give him this so that he could simplify tracking his reviews of the movies, and even whom he has loaned movies to.

The problem I have just encountered is this. I'm creating a program to track my opinions of movies, actors and studios. I have a table for the movies, one for the actors, and one for the studios. I want to be able to enter the cast through a portal in the movie table. I can create entries in the actors table through my portal from the movie table, but the problem is that if an actor is in more than one movie there is more than one entry in the actors table. Anyone have any ideas as to how I should proceed?