You should be storing the ContactID in the Studies table. All you need to do is use the form wizard to create the form based on the Studies table, or a query of that table.
Then, in design mode, change the ContactID text field on the newly created form to a ComboBox (Right-click on the TextBox, Change To-->ComboBox). You will want the following settings in the properties for the ComboBox: On the Data Tab: Control Source: ContactID (this should already be set by the form wizard) Row Source Type: Table/Query Row Source: Click on the ... on the right and query for the ContactID and FirstName - LastName1 (two fields) from the Contacts table Bound Column: Leave it at 1 (the ContactID field) On the Format Tab: Column Count: 2 Column Widths: 0";2.5" (this makes the first column invisible; you can play with the second value as needed) This will allow the user to simply choose a name from the combobox and the ContactID will be inserted into the Studies table. HTH, Toby ----- Original Message ----- From: "Joe" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, December 05, 2005 1:59 PM Subject: [AccessDevelopers] Re: Drop Down to Select Contact > 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 [email protected], "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 [email protected], "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 > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ 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/
