Search results

For this table: Project Table: Project ID, Site ID (Investigational Site), Detail ID (Protocol # and Product), Budget, Study Start Date,Study Completion Date, Comments, Precision Site I need a form that has the following combo boxes : Combo Boxes: * Site ID - display Investigational Site...

Okay I need some help with cascading combo boxes. See below: Master Site Table: Site ID (Investigational Site), Investigational Site, Mailing Address, Mailing Address 2, Mailing Address 3,Mailing Address 4, Mailing Address 5, Mailing City, Mailing State, Mailing, Zip Code, Mailing Country...

okay i think i get it...i have the structure set up now. just need to figure out how to work cascading combo boxes. any help you can send my way would be very appreciated!

so let me see if i get what you are saying. i dont need to put site id, personnel id, and employee id in the contacts table? how would that work since i have to know who is linked to what. there are going to be 1000s of sites and 1000s of personnel....

forgot to mention. items in () are needed on reports that are being printed. also they need to show up on the forms so that the user knows they are entering the correct information

okay here you go look at this excel breakdown that i have made - maybe this will explain what i am trying to do. i dont know how else to explain it and its just getting frustrating.

let me explain this a little more... each site has more than one employee thus there is a personnel table...each site can participate in more than one project - thus the project table.... now the contacts table - there is a required report that needs to be printed which includes the site name...

I am starting the DB again with this information but I have a question. Table 1 - Site ID (Primary Key) Table 2 - Personnel ID (Primary Key), Site ID (Foreign Key) Table 3 - Project ID (Primary Key) , Site ID (Foreign Key) Table 4 - Contact ID (Primary Key) The Contact form and report that...

I am a little confused on what you are talking about the ID being an actual key not an identifier.... the ID is an autonumber - the primary key so doesn't that mean it is used as an identifier for the data in the rest of the row in the table?

could you explain a little more about #1 please

i tried that and it didn't work for me...maybe i am doing it wrong?

okay i understand the auto expand and thats great....but how does it help with something like all the ID's i will be using since they are all numbers....so many numbers!

Yes I will be using forms. That's what I thought - My issue now is that there could be 1000s of entries so the combo boxes would be insanely long!

I am trying to work on a database and now I am getting completely confused and need some help. Can someone explain to me how primary and foreign keys work? Here is a basic structure of what I am planning. Table 1 Site ID Site Name Site Address (broken up of course) Table 2 Personnel ID...

thank you so much. i am going to start over :) would it be okay if i asked you a few more questions (if needed) through this process?

Okay so I am running across some problems. I was hoping you could take a look at the DB and help me out a little. I think it will make more sense once you see it. One of the problems I am having is that each site may work on more than one protocol, thus each site personnel will work on more...

table 1 - site table - fields include items like ID (auto number), site name, mailing address, shipping address etc. table 2 - site personnel - ID (linking to sites in table 1), name, phone, fax, email table 3 - phone contact table - ID (linking to sites in table 1), date contacted, person...

I just want it to make sure the name is already in the DB (I understand if someone miss spells a name it can create duplicate fields but this is better than people not entering their contacts into the DB) in the other table and store it in the phone contact table as well so we know who...

I was able to do that. I would consider just leaving it as a drop down menu but there will be 1000s of entries for this field and that would take forever for someone to enter data.

sadly no. everything is basically way over my head.