Mike Fizer

Thank you bd. You know if it's not one thing it's another. I haven't a clue as to how to find your attachment. I've seen this in other threads, but can't seem to find where these attachments are. Oh! I found them, but I searched by Define Fields and found no post. Again thank you and I'll check out the Max calcualtion you mentioned above. Best, Mike

Thank you bd. You know if it's not one thing it's another. I haven't a clue as to how to find your attachment. I've seen this in other threads, but can't seem to find where these attachments are. Oh! I found them, but I searched by Define Fields and found no post. Again thank you and I'll check out the Max calcualtion you mentioned above. Best, Mike

Thank you bd. You know if it's not one thing it's another. I haven't a clue as to how to find your attachment. I've seen this in other threads, but can't seem to find where these attachments are. Oh! I found them, but I searched by Define Fields and found no post. Again thank you and I'll check out the Max calcualtion you mentioned above. Best, Mike

John, thank you for replying. I'm still a little fuzzy here. The main layout would be the parent table with each subject having it's own related table. Am I generating this file record with a calculation field? Such as a series of If statements, one for each subject table? IF ( Subject="Aircraft", result

John, thank you for replying. I'm still a little fuzzy here. The main layout would be the parent table with each subject having it's own related table. Am I generating this file record with a calculation field? Such as a series of If statements, one for each subject table? IF ( Subject="Aircraft", result

John, thank you for replying. I'm still a little fuzzy here. The main layout would be the parent table with each subject having it's own related table. Am I generating this file record with a calculation field? Such as a series of If statements, one for each subject table? IF ( Subject="Aircraft", result

I am an average user of FM6 and the magazine I work with has a small FM6 flat file for photoshoots with very basic information; Title of Article, Subject, Photographer, etc. My question concerns the File field which is alphanumerical label for the actual folder containing the images, the folders are filed by subjects. Each value in the Subject field has a two letter designator used in the File field. (AC for Aircraft, AR for Airports, CN for Concepts, etc) This label is manually entered. One has to find the last occurance of AV, write down the next number and then locate the last occurance of CR and so on. I would like to generate the file information based off the choice I make in the Subject field, and did this with an "If" statement in the " file field, but it generates, as you'd guess, one set of consecutive numbers, as in AR001, AV002 or CN003. The magazine filing system has each value in the Subject field having it's own set of serial numbers. Would the solution require separate tables for each value in Subject? I'm not sure how to have a record created in another table triggered by a choice made in another related table. I'm not explaining this very well am I. I'd like to choose Aircraft in the Subject field and have the next number AVxxx automatically entered into the File , if I were to choose Airport in the Subject field, the next occurance of ARxxx would be calculated for the File field. Each value in Subject with it's own set of consecutive numbers but all the records displayed in the File field. Thank you for you patience, I hope someone has a suggestion. I really feel for the poor fellow who's putting the data into this table, it's just a silly way to do things. Best, Mike

I am an average user of FM6 and the magazine I work with has a small FM6 flat file for photoshoots with very basic information; Title of Article, Subject, Photographer, etc. My question concerns the File field which is alphanumerical label for the actual folder containing the images, the folders are filed by subjects. Each value in the Subject field has a two letter designator used in the File field. (AC for Aircraft, AR for Airports, CN for Concepts, etc) This label is manually entered. One has to find the last occurance of AV, write down the next number and then locate the last occurance of CR and so on. I would like to generate the file information based off the choice I make in the Subject field, and did this with an "If" statement in the " file field, but it generates, as you'd guess, one set of consecutive numbers, as in AR001, AV002 or CN003. The magazine filing system has each value in the Subject field having it's own set of serial numbers. Would the solution require separate tables for each value in Subject? I'm not sure how to have a record created in another table triggered by a choice made in another related table. I'm not explaining this very well am I. I'd like to choose Aircraft in the Subject field and have the next number AVxxx automatically entered into the File , if I were to choose Airport in the Subject field, the next occurance of ARxxx would be calculated for the File field. Each value in Subject with it's own set of consecutive numbers but all the records displayed in the File field. Thank you for you patience, I hope someone has a suggestion. I really feel for the poor fellow who's putting the data into this table, it's just a silly way to do things. Best, Mike

I am an average user of FM6 and the magazine I work with has a small FM6 flat file for photoshoots with very basic information; Title of Article, Subject, Photographer, etc. My question concerns the File field which is alphanumerical label for the actual folder containing the images, the folders are filed by subjects. Each value in the Subject field has a two letter designator used in the File field. (AC for Aircraft, AR for Airports, CN for Concepts, etc) This label is manually entered. One has to find the last occurance of AV, write down the next number and then locate the last occurance of CR and so on. I would like to generate the file information based off the choice I make in the Subject field, and did this with an "If" statement in the " file field, but it generates, as you'd guess, one set of consecutive numbers, as in AR001, AV002 or CN003. The magazine filing system has each value in the Subject field having it's own set of serial numbers. Would the solution require separate tables for each value in Subject? I'm not sure how to have a record created in another table triggered by a choice made in another related table. I'm not explaining this very well am I. I'd like to choose Aircraft in the Subject field and have the next number AVxxx automatically entered into the File , if I were to choose Airport in the Subject field, the next occurance of ARxxx would be calculated for the File field. Each value in Subject with it's own set of consecutive numbers but all the records displayed in the File field. Thank you for you patience, I hope someone has a suggestion. I really feel for the poor fellow who's putting the data into this table, it's just a silly way to do things. Best, Mike