Recent content by scampbell70

Bob, I think I have it finished what does this look like to you? Is it okay?

I figured I was all wrong about what I had done. I started working on it last night but did not want to post until I got your response. Here is a relationship table of what I have now is this getting better, or am I still all wrong. I have read three books and watched several videos on basic...

I work for a mental health agency that provides mental health and substance abuse treatment to individuals who are incarcerated. When someone comes in they are placed in various programs and each program can have several groups. We need to be able to track patients by stay (IE...

I edited the post I did not realize the file was too big it is there now

I think I did this all wrong and I was going to redo it before I uploaded it but I will just upload the one I been working on.

Bob, If I upload a major project I am working on for my job would you look at the basic table structure and tell me if it is correct. I was using the customer database to teach myself what I need to know because customer examples seem to be all over the internet but I do not know how well it...

Thank you very much.

Okay, so once I set those tables up following that structure how to I create a button to open a new order to the current customer? And thank you for all the help.

I am VERY new to access, I was using orders to store the information, is that a bad idea? My thought was Customer info table Table with all my products Everything else orders table

I have a Tbl with CustomerID, FirstName, LastName, Address, etc I have another table TblOrders ProductID OrderID CustomerID ShipmentStatus ShipmentDate ShipmentMethod I created a one to many relationships between CustomerID in both tables When I click open form it opens the orders form...

I would like to create a button that will open a new record to the currently selected record. I am in customer 1's record and I want to add a new order. I would like to be able to click add new order and have the form pop up and the customer field already populated. I sure this is a simple...

Okay, I made some changes. I have not combined the tables into one yet like you suggested because I am starting to confuse myself LOL. Am I close to being on the right track? I have things like linkstatus and ProgramName, ProgramStatus in their own table so that if I program name needs to be...

Plog, I will give that a try and let you know how it goes. A judge cannot be assigned to multiple courts but one court can have multiple judges that's what I was trying to set up, did I do that wrong? When I print a report the key items I absolutely have to have are the patient's name, the...

It is a program for inmates who have alcohol and drug addiction issues. An inmate comes into the jail and we assess them and provide treatment. When they complete treatment they may be released or they may spend several more months in jail. When they are released we refer them to outside...

Hello, I am brand new to access, but I am not new to the world of computers. I work for a mental health agency that operates a treatment program within a jail and we need a way to track patients, outcomes, etc. I have only worked for this agency about a month and prior to that, they were trying...