Recent content by dunebuggy

Thank you for replying Minty. I understand the relationships better now. With reference to form design, what kind of a control would I put on a form, making it as easy as possible to choose several countries?

From what I've read it seems best to avoid using multivalue fields for a number of reasons. I haven't been able to find out the ideal way to approach it, however. I want to design a form to capture the various countries in which a study was performed. Without using the mvf option in Access...

Thanks again. Let's see if I follow, is this correct? tblCompStudies would capture the list of companies that were in the running for a particular study tblStudyStatus is for the status of a study, e.g. planned, setup, ongoing, completed tblStatus lists events such as....RFI received? This...

Thanks for the quick response Minty. So, would the tblStatus include Yes/No data type against fields for RFI, RFP and Award?

I'm very new to Access. I work in outsourcing for a drug company and we employ contract companies to work on our behalf. Currently I've set up a table called CompaniesT which has one-to-many relationships to other tables called ContactsT (our contacts at the vendors) and StudiesT (the clinical...

Hi folks, I'm a newbie to Access. I work for the clinical trials outsourcing department of a small pharmaceutical company and want to use it to link together our clinical trials and vendors I'll be asking a lot of basic questions, so I hope you'll be patient! Thanks in advance, Matt