May 15, 201015 yr I am back again but not sure where to post this so i chose here since i had such great success with the other. ------ Any ways i am creating a database that will help manage animals. I currently have just one layout but need multiple layouts. I want my main lay out to have a multi page feel. For example - On the main page i want the information on the animal then another layout called Husbandry which will hold the information on feeding and such. Next i want another layout for medical, and breeding, and so on. I have tried creating another table to keep things clean but i cannot seem to link info from one table to another. Or should i just use one table and put the information from one table through out multiple layouts.
May 15, 201015 yr I have tried creating another table to keep things clean but i cannot seem to link info from one table to another. First you will need to give all the animals a unique identifier. Use this as the match field between tables by making a connection between two tables in your relationship graph. You can then display the related information in a portal or you can use the 'go to related records' script step to link to the related information for an animal. Or should i just use one table and put the information from one table through out multiple layouts. You can create as many layouts as you see fit to display information on a given animal. However, I would not necessarily create a new table unless an item for an animal will be repeated many times. For example if an animal has multiple medical entries then you can create a new table for this, and then link it to the animals main record via its ID number.
May 15, 201015 yr Author ok so i have already implemented an id number on the animals. So i currently have this setup Main table Husbandry table length & weight table breeding table medical table all will be linked with an id (irt id that will keep them together. Each animal will have multiple entries on the other tables except the main table. you said i need to create a relationship for each table that uses a linked id. ill give this a shot. any other tips and hints would be greatly appreciated
May 15, 201015 yr Author can i get some help please. i tried everything i could find and for some reason no luck
May 15, 201015 yr Author It looks like it will. But i am about to head out the door. Ill post a reply after i try it out. Thanks
May 16, 201015 yr Author alrite i gave that file a look and tried it on my own database. an no luck. ill try and explain my setup right now. I have one database with multiple tables. i have my main table which holds my animal records. that has its own layout. next i have a whole new layout called husbandry. inside the husbandry layout i have feeding, shedding, defecation. but the only way i could create feeding, shedding, and defecation portals was to create a husbandry table. Each of the others (feeding, shedding, defecation) has there own tables. I am trying right now to just get one to work so i get the hang of it. the feeding table is the one im trying to work with right now. It has a feeding id number that is set on auto-entry serial. and to link the animal to that record they both have IRT ID: with the main record set at auto-serial and the feeding one to INDEXED. I get this error when trying to enter a new feed. "This operation cannot be performed because one or more required related records are not available and cannot be created" EDIT: All better no more deification Edited May 16, 201015 yr by Guest
May 16, 201015 yr why not attach a copy of your file? This way, we will be using your naming conventions to answer your questions. It will speed things up. Lee
May 16, 201015 yr Looked at your file. I think there's kind of a big difference between deification and defecation!
May 16, 201015 yr Author probably lol i was in a rush. i still have a lot to go through and as well go back and change some things i have a list in-front of me that needs to be changed
May 16, 201015 yr Author ok so i fixed my typo's lol but has any one taken a look at the file for me.
May 17, 201015 yr Author ok can i please get some help with my problem now. I have tried a few different things and have had no luck
May 17, 201015 yr It's quite difficult to understand what you're trying to do. You seem to be randomly creating tables without any explanation of what they're for. Please be very specific. "The feeding table is the one im trying to work with right now." How? Where? What layout? What is supposed to happen? I don't know what you're talking about. Another note - wow, you have colons in the field names! "IRT ID :" That seems very likely to confuse things, confuse setting up relationships, etc. Get rid of all the colons AND all the trailing spaces. Edited May 17, 201015 yr by Guest
May 17, 201015 yr Author sorry for the confussion. My goal is to keep track of reptiles. I have created one table for the reptile information and have created other tables for keeping track of each reptiles feeding, medical conditions, shedding, etc. I said that i was working on the feeding one because i want to tackle one at a time or figure one out and then do it to the rest. once complete each reptile will have a record and a area to keep track of there feeding. the feeding table needs to be inside of the husbandry layout. ill attach a new version of the database the username is Tyler Yates there is no password v1.0.2a.zip
May 17, 201015 yr I get this error when trying to enter a new feed. "This operation cannot be performed because one or more required related records are not available and cannot be created" But that's how you defined the field validation.
May 17, 201015 yr Author ahh i see i should set it up to be modifiable (not sure if thats a word )but to prohibit the users from changing it turn of the field entry on browse layout etc. Right??
May 17, 201015 yr Author ok i have changed the prohibit modify. now i dont get an error message but it does not link the records i can access all the records from each reptile
May 17, 201015 yr Ok, take your hands off the keyboard and step back from the computer. You're going to hurt yourself. You need to learn a bit about relational databases. My goal is to keep track of reptiles. I have created one table for the reptile information and have created other tables for keeping track of each reptiles feeding, medical conditions, shedding, etc You need to work out what the ENTITIES are. These become tables. Tables aren't made on a whim. You then need to work out what the relationships are between each entity: they can be one-to-many or many-to-many. A many-to-many relationship needs a join table. You probably need a table for each reptile: REPTILE TYPES. If individual animals are being tracked then probably a table needs to be made for them: ANIMALS. The Animals table gets related to the Reptile Types table. If you need to record each time an animal sheds its skin, then a SHEDDING table is needed: it will be related to the Animals table. If however you only need to store information about how often an animal sheds its skin then a field in the Reptile Types table will do. The same kind of analysis needs to be done for feeding, medical conditions etc.
May 17, 201015 yr Author ok thanks for the clarification. i think that i am going in the right direction. i dont think i need a table for each reptile but a record. but i need a new table for each of the other items (feedings, medical, shedding, etc.). only because i need to track multiple feedings, sheds, medicals. so far each reptile there will be a feeding, shedding, medical etc. but will only show the feedings for that reptile. from what i have been reading i just need a unique identifier for each animal and then link that identifier into each table i create. Am i getting this right? Heres the link to a runtime application that i am trying to follow but for personal use only. but it shows what i am trying to accomplish. http://cdn.thereptinetwork.com/vrts.zip EDIT: the attachment was by accident the file is to be to be an attachment it will not allow me to remove it Edited May 17, 201015 yr by Guest link updated
May 17, 201015 yr ok i have changed the prohibit modify. now i dont get an error message but it does not link the records i can access all the records from each reptile What in the world do you expect us to do with that? There's no information there; and no file. What in the world are you talking about? Nobody knows. Nobody CAN know. There is no detail. You're wasting our time. You're asking experienced people for free help and you need to be FAR more forthcoming with meaningful detail, such as the file; and the layout and button and script and relationships involved.
May 17, 201015 yr GET RID OF THE COLONS in the field names. Defecation still misspelled. Edited May 17, 201015 yr by Guest
May 17, 201015 yr Bruce, xTYATESx has only been on these forums for a few days. Good grief, lighten up. xTYATESx, you aren't wasting our time. Edited May 17, 201015 yr by Guest
May 17, 201015 yr Vaughns advice is the best route. Once you develop a solid understanding of efficient relational structures then you'll be able to communicate your questions so forum members wont have to struggle for comprehension and can actually help.
May 17, 201015 yr Author jeez. sorry for the small human error on the link and attachment. nobody is perfect. as well my profile shows that my skill level is low very very low. I am trying to figure this out and learn something new. i am not trying to get something for free. Lee Smith suggested i upload the file so i did. I have searched the forums and cannot find anything similar.
May 17, 201015 yr Bruce, xTYATESx has only been on these forums for a few days. Good grief, lighten up. xTYATESx, you aren't wasting our time. He's providing unclear questions then directly asking OK can somebody help me now. There is a reason he is not getting useful help - because it is impossible to provide it if he asks us to play guessing games by giving insufficient information. Your acting as an enabler is not helpful.
May 17, 201015 yr Please don't start with the personal attacks on me. You can nicely ask someone for more information without blasting and whipping them with several posts in a row. If you will read the entire thread, this person has been providing a lot of information for us. If you don't want to help then don't but don't beat people into your submission. xTYATESx, don't worry about it. There are many types of people on these forums; some simply have zero tolerance. Just ignore those who are rude and do the best you can and don't sweat it . :wink2: Edited May 17, 201015 yr by Guest
May 17, 201015 yr Author i can see its a very diverse community. ill try posting in a new area since i just found it.
May 17, 201015 yr It won't matter where you post - most Developers who assist on this site read all forums and forum policy doesn't encourage double-posting. You will need to learn to take a deep breath, use input which is valuable and ignore the rest. You have done nothing wrong. :^)
May 17, 201015 yr Author So i just started using FM and have really no experience at all but i am learning as the days go by. My plan is to create a reptile tracking database that will help keep track of my reptiles and possibly distribute it out to others. I have gotten a couple of the layouts done and am now at a dead stop on how to link feeding records, medical records, shedding records, defecation records, and a few others. I have setup the tables for each but i am having a hard time linking a specific reptile to its own feeding records, shedding records, defecation records, etc. I have a layout called "IRT Record List" this will hold each reptile. My next lay out is called "IRT Husbandry Records" which has three tables in it that are setup as portals. One portal is the feeding table, the others are shedding and defecation. I am trying to get each portal to link to that specific reptile in the "IRT Records List" I want to be able to create a new animal and then click the husbandry button and it will show that animals husbandry records. I do not want to use tabs. This is the software that i am trying to mimic : Link Its the same thing just a bit more advanced. Ill attach my own database that i have been working below. I have tried creating relationships in all types of ways. But when i think i get it i dont. It ends up just creating record for all animals. EDIT: The username is Tyler Yates No passwod v1.0.2a.zip Edited May 17, 201015 yr by Guest added username
May 17, 201015 yr Author ooh ok well i just posted a new topic in the Relationships section on this site. which should be much more detailed. http://fmforums.com/forum/showtopic.php?tid/214834/pid/356635/post/last/m/1/#LAST
May 17, 201015 yr To Original poster... I did not intend to offend or discourage. I simply agreed with Vaughan because your skill/experience level was pretty obvious and some basic relational theory learning would be great place to start.. You wouldn't want to try and repair an engine if you had to ask what a wrench was right? Don't give up. Your just on the steep end of the learning curve. K
May 17, 201015 yr Author oo sorry i must have hit the wrong reply button. i was not directing that to you but Bruce. i am trying to figure this whole thing out. i know websites and stuff like that but not this stuff so its new to me.
May 17, 201015 yr Hi Tyler, This is a window's runtime file. I would have preferred to be linked to the site instead, where I could read about the file, and maybe see some screen shots, and download if I felt I need it in order to help you. You can change the word "[color:blue]Link" in the "[color:blue]Text for Link" box to anything you want. In this case, I would have used "vts.zip" with a note that it was a window runtime file. Personally, I have no interest in downloading a file from a strange site without knowing something about the site, and the linked file. Lee
May 17, 201015 yr Author sorry about the Lee The link to to the download is a cdn site i use for my site. Here are links to his pages Main Link : Main Page User Guide : User Guide
May 17, 201015 yr ooh ok well i just posted a new topic in the Relationships section on this site. which should be much more detailed. http://fmforums.com/forum/showtopic.php?tid/214834/pid/356635/post/last/m/1/#LAST There's no Topic from you in the Relationships section.
May 17, 201015 yr Hi Tyler, I have merged your two threads. Please do not double post. Double posting can be a waste of everyones time. Ours because we have to jump between your threads to read the advice, in order to ensure we are not suggesting the same thing that someone else has already provided. Yours because, there are often more than one way to accomplish the same thing in FileMaker. If you have ever tried to follow the advice spread over a couple of threads, you will find it hard to absorb the advice because it will be in chunks and probably describing different ways to accomplish your goal. We know that the Forum can be confusing trying to figure out where to post a question. All we ask is for you to try and match one of the topic areas to a function or feature that you think might be part of your question. Not to worry, if you miss it a mile we can always move it if it needs to be. HTH Lee
May 17, 201015 yr Hi DJ, You're to quick for me, or I'm moving kind of slow today. I was typing out my explanation as to why I merged the two threads. :giggle:
May 17, 201015 yr In the interest of moving this forward: Why don't you start with something simple, see how it works, then expand on it? Reptiles.zip
May 17, 201015 yr Author ill try that and then work out into the bigger one. see me being a person more into web development i tend to design first then setup the backbone
May 18, 201015 yr Author ok so i tried using you example and the only problem is that if you do not have a current feeding record in place already then it will not work you have to physically go to that layout and create a new one. is there a way to have a new record automatically created?
May 18, 201015 yr Author when you delete every record in your example and then create a new animal the feeding table should have a default record setup with that animal. if not then it would be kind of time consuming to have to go into the feeding layout and create a new record
Create an account or sign in to comment