I have a form in Access that is connected to one table. i want to make a new list that have some information from a different table but this table have a shared field with the first table.
HOW?!?!?
thanks, Lin.
p.s. - If you didn't understand my explanation let me know and i will try again..
The easiest way to do this is to link your 2 tables by tampering with the relationships option (under the tools menu) as in the sample attached.
Once you've added your join/relationship between the tables, you can then use the "create form by using wizard" option in access (under the forms selection of the main window) and select the fields you need from both tables from the 1st stage screen of the wizard...
Please rate this post if it was useful for you!
Please try to search before creating a new post,
Please format code using [ code ][ /code ], and
Post sample code, error details & problem details
1. the form is written already - so wizards is out of the Q
2. My 2 tables are with relation one to many.
the first table is the Employees names ect.
and the second table is the salary of the Employees.(Employee ID is the record that they share)
I need to show on the form the details of the employees and in each record of the employee i need to show the history of his salary.
simple one..
Reply With Quote
