need a solution! help pls..

[jammie]

im using filemaker 6. hope this is not too silly a question.

i have 2 files. one file is 'category listing', the second one is 'main'.

there are 2 fields in 'category listing' called and .

there are many fields in 'main' file which includes and , , .

i created a relationship to link the 2 files such that in the 'main' file, when i choose a category, it will shortlist the various 'sub categories' under it only. this works already.

however, i want to make it such that when i add records under the 'main' file, the category and subcategory will also be added into the 'category listing' file.

pls advise! i need the solution rather urgently.. thanks so so much!!

[Fitch]

You don't have the "Edit" option when using related values. The alternative is to make a script in the category file for creating a new record, and a button/script in the main file that runs this (external) script.

[jammie]

I see! I kept fiddling with the relationship settings, thought I made an error there.

YAY got the scripts!! Thanks Fitch! :