Multi ?

[xTYATESx]

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.

[Matthew F]

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.

[xTYATESx]

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

[xTYATESx]

can i get some help please. i tried everything i could find and for some reason no luck

[efen]

Does the attached help?

animal.zip

[xTYATESx]

It looks like it will. But i am about to head out the door. Ill post a reply after i try it out.

Thanks

[xTYATESx]

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, 2010 by Guest

[Lee Smith]

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

[xTYATESx]

why didn't i think of that sooner. Will do Lee

IRT_-_Record_List.zip

[efen]

Account name and password?

[xTYATESx]

Account Name Is Tyler Yates

No Password

[xTYATESx]

is there an update yet.

[bruceR]

Looked at your file. I think there's kind of a big difference between deification and defecation!

[bcooney]

I haven't read this thread, but my, this last post sure caught my eye, lol.

[xTYATESx]

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

[comment]

Hey, deification happens...

[xTYATESx]

ok so i fixed my typo's lol but has any one taken a look at the file for me.

[bruceR]

Hey, deification happens...

Seems I was even told recently it happened to me ;-)

[xTYATESx]

ok can i please get some help with my problem now. I have tried a few different things and have had no luck

[bruceR]

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, 2010 by Guest

[xTYATESx]

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

[bruceR]

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.

[xTYATESx]

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??

[xTYATESx]

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

[Vaughan]

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.

[xTYATESx]

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, 2010 by Guest
link updated

[bruceR]

Your attachment doesn't exist.

[bruceR]

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.

[bruceR]

GET RID OF THE COLONS in the field names.

Defecation still misspelled.

Edited May 17, 2010 by Guest

[LaRetta]

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, 2010 by Guest

[Kris M]

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.

[xTYATESx]

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.

[bruceR]

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.

[LaRetta]

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, 2010 by Guest

[xTYATESx]

i can see its a very diverse community. ill try posting in a new area since i just found it.