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

I think that you should create a related table with all of your subjects and then either you can create related tables for each of these or you may be able to create one big file containing all your numbers if that is the only other information you will require.

On the main layout, you can have a pull down with all the subjects. When you make the relationship between the Main and the Subject tables, amek sure it is a sorted relationship by the number field. Then you can have a button, "Get next number" that creates a new entry based off the last value of the related number field + 1.

The Main layout will then show the new value for that particular subject in a field.

I think that you should create a related table with all of your subjects and then either you can create related tables for each of these or you may be able to create one big file containing all your numbers if that is the only other information you will require.

On the main layout, you can have a pull down with all the subjects. When you make the relationship between the Main and the Subject tables, amek sure it is a sorted relationship by the number field. Then you can have a button, "Get next number" that creates a new entry based off the last value of the related number field + 1.

The Main layout will then show the new value for that particular subject in a field.

I think that you should create a related table with all of your subjects and then either you can create related tables for each of these or you may be able to create one big file containing all your numbers if that is the only other information you will require.

On the main layout, you can have a pull down with all the subjects. When you make the relationship between the Main and the Subject tables, amek sure it is a sorted relationship by the number field. Then you can have a button, "Get next number" that creates a new entry based off the last value of the related number field + 1.

The Main layout will then show the new value for that particular subject in a field.

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

You can do this without a second table using and auto entered calculation an one relationship. The reationship matches Subject code to Subject code. The serial number part of the ultimate code (AC001) is an auto entered value by calculation defined as Max (Relationship::Serial No.) + 1, set to always evaluate. Example is attached.

-bd

You can do this without a second table using and auto entered calculation an one relationship. The reationship matches Subject code to Subject code. The serial number part of the ultimate code (AC001) is an auto entered value by calculation defined as Max (Relationship::Serial No.) + 1, set to always evaluate. Example is attached.

-bd

You can do this without a second table using and auto entered calculation an one relationship. The reationship matches Subject code to Subject code. The serial number part of the ultimate code (AC001) is an auto entered value by calculation defined as Max (Relationship::Serial No.) + 1, set to always evaluate. Example is attached.

-bd

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