Orchid28

Well here is what I have. I am not too familiar with how relationships work so I'm not sure if I am doing this correctly. The BIA table is the main table. I will need to input data into the Control table and the Definitions table. The definitions table is just a reference table of what each field means The Control table is basically an expansion of the BIA Table When I am in browse mode I am unable to add data to the empty fields in both the Definitions and Control tables. I can only input data in the fields that already have data in it. Document1.doc

Yes I think it has something to do with the relationships between the tables I have. There are 3 tables and Table 1 is my main table and I am able to edit the fields. But Table 2 and Table 3 I can not add any data to the blank fields. I don't know what I did wrong with the relationships between the tables though. When I remove the relationship graphs the empty fields on Table 2 and 3 says <unrelated table>. Any suggestions?

Well some fields I have data in it and I am able to edit and add data to it and the fields that dont have data (its just a blank white space) I can't input anything into it.

I don't know what I did wrong but I can't input any new data iinto any of my records. Whenever I click into a box to add in new information about a project that is in progress it won't let me type into it. I am in Browse mode so I don't know why its limiting me.

Ok so Table 1 has all our records of the projects we are currently working on and it also lists projects that are finished. My manager wants to be able to easily search for a certain project from Table 1 and find its "Control number" and what the control number means from Table 2 (sort of like a reference table). I've decided to make a button on Table 1 that will lead to Table 2. Right now I have this button and when I click on it, it goes to Table 2. Table 2 has none of my records listed from Table 1. so Table 2 only has ONE record for all 100 records from Table 1. Am I suppose to import data to Table 2? The two main relationships I have for both tables are Risk Number and Type. Hopefully this makes sense. I could make Table 2 into the same layout as Table 1, BUT Table 1 already has other related fields such as a scorecard. My manager wants 2 tables so the data is not all meshed into one layout (one Table).

I'm a little unclear as to how I can go about with my relationships. I have two tables. The first table shows all of the company's risk record which are projects that we have finished and have not finished or projects that are in progress. The second table shows the risk records' Control ID which is like an ID for each risk record (I have about 100 records by the way). This second table is like a reference section that catergorizes what control ID each risk record falls under. Here's an example of what I have in each Table: Table 1: (Risk Record) Type Criticality Rating Status/Actions Issues Resources required Start Date End Date Completion status Risk Number Table 2: (Controls) Risk Number Type Control Description Control Sub Number Control Sub enhancement So far Risk number is the Primary Key. But now what? I don't understand what script I'm suppose to use, or how to use it, if I should make a button that leads from Table 1 to Table 2. My manager wants to be able to find a risk records control ID. So how do I go about this? Sorry if this all seems confusing. Please ask any questions to clarify! Your help is deeply appreciated!

^Thank you. When I insert // for the current date it does not show the current year just the month and day. It looks like this 3/1/ How can I get it to show the month day AND year?

I need to figure out how I can add a header, a footer, a page #, and current date onto the Table View?

Hm okay, its just a temporary thing so I can just make new layouts and delete when its all printed.

I have several fields. They are start date, end date, Actions, Status, Recommendations, and etc. I have about 100 records. I was asked if I can print ONE field (instead of the entire data with all other fields). My coworkers only wanted to print out (one field) which was the Recommendations for a meeting but I was not able to. Is there a way that I can do this?

^^lol ok got your corrections...I guess its time for a vacation!

Okay great! and yes I have NO skill level what so ever lol but I am learning and I thank this forum and you for helping me through my first database! I will try this out! thanks.

Okay so I have 2 fields, one is StartDate the second is EndDate. The user won't be inputting the dates in StartDate and EndDate at the same time. If the user wants to look at the start date they will input the "oldest" date in start date ONLY and leave the EndDate blank with no searches. I'm thinking of including both ascending and descending order so if the user just wants to start with the "newest date" they can do that instead of always starting with the "oldest date". It would probably be better if there are more options to finding the dates. A little more information about my database: Each record I have has a different project that my company needs to address or accomplish. Each record has a Start Date of when my company started the project and an EndDate of when my company finished the project. So what my coworkers are looking for is an easier way to search for the StartDates and EndDates. And what they want is to look for the oldest or newest dates. So when they look at the oldest date it will start from 2010 and they can continue to click till they get to the newest date, 2013 and vice versa. EDIT: Addressing your question above. So far all I have is Field Name: Start Date Type: Date Field Name: End Date Type: Date and no they are not in global fields...i did global fields and it deleted all my data and when I tried to input all the dates back in again it automatically inputs 6/2010 for every record which is totally wrong.

^Yeah I tried the script and it didnt work When I put in 2010, which is the oldest date, it only shows dates from 2010...Not from 2010-2013. And it doesn't go by order so when I'm clicking through the 2010 dates it will show (7/2010, 10/2010, 6/2010 etc.) so the months are random and does not go in ascending order. So like you said I am looking for a script that can allow users to click through records starting from the oldest date to the newest date. Sorry if I wasn't clear enough!

^User is trying to find a quicker and efficient way to find records and one of them is searching by date