The table TRAVEL must contain an ID field from EMPLOYEE, in order for the two tables to be linked.
To avoid confusion, may I suggest naming the ID field in EMPLOYEE to EmployeeID, and the ID field in TRAVEL to TravelID ... then add EmployeeID to TRAVEL as the field linking the two tables. HTH Bryant --- In [email protected], "masuma_tumpa" <[EMAIL PROTECTED]> wrote: > 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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
