Script to perform a find and not modify data when selected

[sapa]

Hi,

the issue im having is with a drop down value list. in my database at the moment is used only for two layouts. namely Project Details layout and Test layout. first of all the user goes to the Project Details layout and clicks new record. then a projectID is automatically created and allows the user to enter a project name, project description. after that the user needs to add particular drawings for a particular project which was created.

then the user goes to the Test layout and it has a drop down list which calls all the project ID's which were created in the projectDetails layout. assume we created a project ID "1" and entered project name , project description under that project ID. and when the user goes to Test layout and select projectID 1 from drop down it shows the project name , project description in the fields next to the drop down. and there the user finds a portal which got editable fields and a button next to it called "Add".

so now the user can select projectID 1 from drop down and when he clicks the "Add" button it allows the user to create new records and include them into the database. so the problem here is. if there was more than one project and after entering data under project ID 1 then the user might select project ID 2 from the drop down and start entering data but it doesnt create a new drawing register instead it overides/modifies the previous register. so i want to have a script to solve this problem but i have no idea how to do it since im a beginner and has been with filemaker only for like 3 weeks. so hoping to get some help. i will attach my file for further clarification.

thanks,

DBtest.zip

[comment]

I am having a hard time understanding your file. What is the purpose of the "drwaingRegister" and the "registerDrawing" tables?

Can a drawing belong to more than one project?

[sapa]

I tackled it and came up with something . now its working. what basically happens is. you goto projectDetails layout and there by clicking "new record" you can create a new project. and once you goto "Test" layout it will show the projects you created in a drop down. then you can select a particular project and click the "Add" button next to the portal which will create an editable record in the portal and start entering the Drawing Details. the problem im having now is with a field called revision number. now imagine a project has a drawing register which is what we are doing by selecting a project from the drop down and starts entering data into it in the portal which makes the drawing register. BUT assume that the the architect decides tomorrow that we need to add two more drawings to the register but for now we have only 5 drawings where the register is not revised its brand new.and the revision number is 0. tomorrow we add another 2 more drawings then the register is updated which means the register is been revised then the revision number turns to 1. so now when we select project no 1 in the drop down it should show the drawings we had in revision 0 and the drawings we have in revision 1 as well (this is done to keep track how many times the register was revised). this is the problem im having now. i managed to solve the problem i mentioned in the previous post. i will attach the current file its a new one because i did the whole thing again dont compare it with the previous file i sent.

DBtest.zip