Have you defined two tables in Manage | Database? Projects and Issues?
Did you link them like this on the relationships tab?
Projects::Project Code = Issues::Project Code
Is Project Code an auto-entered serial number?
If so, use the onRecordLoad script trigger on your Project Code layout to do this:
Set Variable [$$ProjectCode ; value: Projects::ProjectCode]
(Using two dollar signs as the start of a variable's name makes it a global variable accessible throughout the database and a value stored in it will persist until you close the file.)
Then go to manage | database | fields, find Issues::Project Code and double click it.
Click the auto-enter tab and select the calculation option.
enter this as the calculation: $$ProjectCode
Now any new record you create on the Issues layout will create a new issues record and link it to the current record on the project code layout, provided you visit the project code layout first.
You can also use either Go to related records or a scripted find with a button on the Project Code layout to bring up a found set of related issues on the Issues layout.
You can also display the issues records on your Project Code layout in a small scrolling window if you add a portal to Issues on the Project Code layout. If you enable "allow creation of records via this relationship" for Issues, you can add new related issues records directly in the portal and FileMaker will link the two by copying the Project Code of the current Project Record into the Project Code field of the new issues record and you don't have to use the previously described scripting, global variable and auto-enter calculation.
thx for the answer, it helped me a lot....