HeavyE

I have been charged with setting up a database to track keys to employees and outside contractors. So far I have succeeded in setting up a nice relational database which allows me to connect a key to a client. Having a Client file, a Key specs file and a Main file. It has been getting me by so far, but it can definitely be improved. I want to add in a history log. I want to be able to access a key and display all of the people it has been checked out to, with issue dates and return dates. Also I want to be able to access a client and see all keys that are checked out to them, and that have been checked out to them in the past. Can anyone help me out with this?

Nevermind that last

What do i need to change in Print setup? I can't find the option for it.

I have a report and I need it to print it, so that it is 11inch wide not 8 1/2 inch wide. How do I do this? Also i am still very new to this game.

I am very new to scripts and i don't understand much about them. How do you enter in your FIND parameters into a script. I know how to get PERFORM FIND [ Replace Found Set] into a script, but how do i enter in a specific search parameter?

Thank you very much to all who replied. I figured it out. I'm sorry I couldn't post my real data but I could lose my job. Thanks again to all!! And dont worry i might be back with some more fake questions.

That is the only FIND that works for me. Lets say i want to find the record that has a 5 for number3. So i go into FIND mode, type in 5 for number3 and it tells me that no records match.

sorry, messed that up Fake1.zip

Here i made two fake files. I did everything that i have read to do and yet i can't get them to work. fake1 is the master and fake2 is the secondary. I want to be able to type in an ID number and have the rest of the fields fill in. i know this is probably an extremely easy thing, but i'm just lost.

I'm sorry but i can't. They are restricted.

Background: Very new to file maker 6 Problem: i can not get my relationships to work. I referenced 3 different books and i have followed the instructions step by step( and all three are the same) and yet i still can't access any information from the secondary file. I have set up the proper relationship, specified the fields, and when i type in a search to find multiple fields i get nothing. Is there some little step that I am missing??? If anyone can help, by all means. Thank you!

Thank you very much!!

I am very new to file maker pro 6. How do you set up different sorts for different layouts. Say one layout you want to be sorted by date and a different layout you want sorted by client name? Right now I can only do one sort for all layouts...... any thoughts?