StockControl

[Guest_imported]

How can make relationship between this table. 1)tblEmployee 2)tblStock 3)tblUniform
What i want here, when i click Employee NAme field from tblEmployee there will display all the record that Employee have been take the Uniform..
Anybody help me to solve the relationship...
please...

regards,
hafiswan

 

[AlexMidd]

Sorry, it's a little difficult to understand what you need here. What is the actual relationship between the entitities that make up the tables, e.g. can an employee have many uniforms etc.

If so, you need to relate them on a one to many basis (i.e. a field in Uniforms that identifies the employee that it relates to and linked to the primary key in employees). Once this is done you can create a recordset (using a query) that combines the tables and invokes the relationship. For example, if you create a form with the recordset behind it and there is some way fo selecting an employee you can use controls, such as a listbox, to display all the uniforms related to him/her.

This is just an example - I am not sure from your post if this is what you require. Have fun! )

Alex Middleton