Hi there, Hope everyone is well?
I have three tables - Company_info containing (Company_ID,Name, Address) - Contact_info(Contact_ID,Company_ID, First_name,Surname, Tel,email) - Communication_info(company_id,Contact_ID,Date,Reason,Action) I have a form that is based on the Company_info, with two sub forms one shows contact_info for that company, and the next that shows the communication history for that company. I want to put a combi box in the communication subform that will only allow me to choose from the employees that belong to the company record I am viewing. I have managed to put a lookup in the table, however it gives me a choice of everyone in the contact_info table regardless of the company they belong too. Any help much appreciated... -- Chris Nash 07522 189605 follow me on twitter @cjbnash Wave me on google wave chris.nas...@googlewave.com [Non-text portions of this message have been removed]
