Can any one help me. Say I have two tables. one is EMPLOYEE and another is TRAVEL. and the fields are like below: EMPLOYEE ID Name Conteact_Date Work_Location Supervisor
and TRAVEL ID Destination Departure_Date Return_Date Price Invoice_No Now, I want to display the travel informations of employees. In the form I will enter the employee ID and Destination then in the subform it will display the travel informations of the employee in a specific Destination. That means the subform will display the records that how many times the employee travels to that destination. Thanks in advance Masuma ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
