The thing with this is I don't want them to be able to edit the contact info just select from a drop down. Then all that contact info is associated to the study. So do a combine of the First name - Last name and have that as a drop down that is linked to the contacts. I will have a seperate form to enter in contact info. Can I still do that the way you ar talking about Alienwebmaster?
--- In AccessDevelopers@yahoogroups.com, "Richard" <[EMAIL PROTECTED]> wrote: > > It sounds like you already have the relationships developed. Use the > FORM WIZARD in the forms tab of the main DB window, and select fields > from BOTH TABLES that you want to see. The wizard does a very nice job > of creating a main form (with the contact information) and a sub form > (with the studies info). Hope this helps! > > Alienwebmaster > > > --- In AccessDevelopers@yahoogroups.com, "Joe" <[EMAIL PROTECTED]> > wrote: > > > > I am sorry this is probabally a newbie question. I have two tables a > > contact table and a study table. I set up my form to view Study > > details information. I have a relationship of a One (Contact) to > Many > > (Studies) I want to have a drop down so I can select one Contact and > > associate this to a study. How would I go about doing this? > > > > Thanks in advance > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
