Second form not displaying data from 1st form

[skeddy]

Have 2 tables - Contacts and Facilitators. Some Contacts are Facilitators. Facilitators have additional data we collect therefore the 2 tables. <br><br>Built the second form based on a query of Facilitators table and includes the Name fields from the Contact table. Created button on Contacts form to open Facilitators form and display the Name of Contact. However, the Name does not display. The Filter property indicates it found the correct Contact ID. Is there maybe a problem with my table design?<br><br>tblContact<br>ContactID (p.k.)<br>strLName<br>strFName<br><br>tblFacilitators<br>ContactID (p.k.)<br>mmoBio<br>strUsername<br>strPassword<br><br>Should I have a different p.k. in the Facilitators table? And then have the ContactID be a number, long integer type?<br><br>Thanks in advance.<br><br>

 

[DougP]

I would put both in one table and have all of the fields plus an additional one called Type.<br>If they are a Facilitaor then the type for them would &quot;FAC&quot;. If they are a contact then the type would be &quot;CON&quot;<br><br>Then all of your troubles having two different tables go away. You just started and every step of the way you will fight the two table syndrome.<br><br>To merge them together is making an Append query<br>First add the Type to both Table and use an dUpdate queyr to add FAC to Facilitators and CON to Contacts<br>Then open the Contacts and Append them to the Facilitators.<br><br>OK<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[skeddy]

Thank you Doug. There are actually 2 additional tables that also contain Facilitator information: FacilitatorHistory and FacCoursePreferences. From the Contacts form, I'd like to have a button to open a form where the&nbsp;&nbsp;Facilitator History and Course Preference and Bio information is available and have the Contact/Facilitator Name pass into that form. <br><br>I'll try your suggestion of combining the Contacts and Facilitators tables and then build form/s based on that to see if it works out easier. If you have any additional thoughts, I'd love to hear them and I'll keep you posted about my progress with this. <br>Thanks!<br>

 

[skeddy]

Oh, I'm also curious - I have a Yes/No field in the Contacts table called Facilitator. Any special reason why you recommended a field called Type rather than this Yes/No field? Do you see any benefits of a text field over a Yes/No field data type? TIA