Bfabes

WOW! I can't thank you enough for this. I will go through it now. I am sure I will have a few questions. Thank you for taking the time to sort me out. I want to explain two things that will hopefully clarify what I was trying to do. The pulls downs on the Art Assets page. I thought to use those for the user to establish what Project they are associating the new asset with. The thing is I have been saddled with a naming convention that is rather cumbersome. All our assets are coded like this. The convention is: 000_Veh_Name 000 - is the serial number assigned. Veh - is the category of asset Here is my problem. Each category has it's own set of serial numbers. The naming convention was setup backwards but it's what I was given. So for the category SET there are 120 names. For VEH there are currently only 32 Names but all are different from SET. That's why I kept the Serial pull down just the actual numbers. The conditional pull down for Category established what Project Names filled the third pull down. The Project Names are entirely dependent on the Category type. As for the Look Up page. I am sure it was misguided. What I was trying to do is I wanted to create a page for the producers to go to so they could use the pulldowns to select the appropriate Project they want to see. I realized that if I just used the same pulldowns from the input page, it was changing the original records in the Project Table. That can't happen. I thought if I recreated the pulldowns and have them populate a new table, that is only used to store the producer's choices and then look up the appropriate records in Projects and Assets that I could avoid changing the original records. And then Layout #4 would populate with the appropriate info. So that takes us back to my problem of how do I let the producers select the Project they want to see and have the report fill in the proper info based on the Project name they have selected? My first attempt populated a pulldown with all the concatenated Project Names but as you can imagine, that pull down became way too long with all the possible combinations. Thank you again for all of this. I will start going through it now to make sense of it all.

Please do as you will. I have spent days scouring this message board for answers and it is a great resource but I am lost. It would not be an insult. I realize this is probably a simple DB to construct if I had time to read my Missing Manual book. The basic gist is that the Projects share the same name as the assets except the assets have another section in their name to further describe what they are as a component. The producers want a top down view of the project and it's status. So If they pull up the report by the general name 005_Veh_Lightcycle. they want to see the status of all the assets associated with the Project name. Thank you for taking the time to look this over.

You would be correct. It's that obvious huh?

Hi, I am working on a movie and I have been asked to create a DB in FMP to track all of our digital art work. I am very new to FMP. Each Project has multiple smaller assets. For instance. We are building a lightcycle. That 'Project' is composed of smaller assets tires, handlebars, lights, etc. When the smaller assets are input into the DB, I have 3 pulldowns to assign them to a particular project. An example of the Project name is 005_Veh_Lightcycle. 005 = SerialID (range is 1 - 120) Veh = CategoryID (4 possible categories) Lightcycle = NameID (# is dependent on category) With the various combinations there are 100s of project names. What I need help with is creating a report/search page where someone can search for a specific project and have the report give them all the data on the smaller assets. How do I create a report that will give the specific info for a single project chosen by the user? Do I use the previous 3 pulldowns to create the search parameters and then pass that to something? Is there a better option? I am searching in the dark here. Any help or nudge in the right direction would be greatly appreciated. Thank you.

Let me explain what I am attempting and hopefully someone can provide advice as to the best solution. I have 2 tables. Projects & Assets. Each project is made of multiple assets. When a single asset is entered into FM, it is given a Project name. This project name is created by choosing from 3 value lists I have created. The field names are: 1 - SerialID 2 - CategoryID 3 - ShortName I need all three of those fields to create the ProjectName field. How do I do this? How do I merge all three separate fields into one field called ProjectName? Concatenation? Script? Since the ProjectName field is the link between the Projects Table and Asset Table I need it created in both tables after the user has selected the values from the three value lists. I am very new to FM and I apologize if I am asking a noob question. Thank you for your time and assistance.

Thank you for the help!!

I have been over thinking this problem and now I am lost in the woods. Any information or advice would be greatly appreciated. I don't know if this should all be in one table or broken up in to two or more. I have Projects and Assets. One of my problems is that each Project dictates the name of the asset. Examples of Project names: 001_Veh_Cycle 002_Veh_Plane 001_Env_Mountain 002_Env_Rivers The asset names are 001_Veh_Cycle_Handlebars 001_Veh_Plane_Wings What I need to do is enter data on each individual asset. Design date, artist name, Approval Status, etc. But each Project that is made up of multiple assets has it's own data. Completion date of Project. Delivery Date. Then I need to create a report that will pull up the Project name (001_Veh_Cycle) and then report all the smaller assets with their individual data. I have created two tables. Assets & Projects with the ProjectID as a foreign key in Assets. Is this correct? When creating the report, How do I make sure only the sub set of assets that belong to the project appear and not everything labeled 001_Veh? I hope this makes sense. I am floundering here. Thank you for your help.