how to make relationship?

F

Faiz

i have a database of computer inventory, in which i have various tables like
owner,total cost,purchase type and so on.
movement means transfers of PC from one employee to another and in owners
table i record existing, previous and next(probable) ownership of the
machines,
now the problem is when i open main form that is of computer inventory and
then the owner's table, it shows all the records of machines in owners table.
if anyone can help me in this matter i'll be very thankful to him.
 
F

Faiz

the object of this database is to maintain inventory of all computers in the
company. below are the some of the fields.... i think u can get an idea from
it.

1-movement
*previous employee#1
-employee name(text)
-designation(text)
-department(text)
*previous employee#2
-employee name(text)
-designation(text)
-department(text)
*existing employee
-employee name(text)
-designation(text)
-department(text)
*next employee#1
-employee name(text)
-designation(text)
-department(text)
*next employee#2
-employee name(text)
-designation(text)
-department(text)
3-total cost
*base price
*shipping & handling costs
*taxes / duties paid
*total cost
*budget expense
-expense type
-quantity
*first year value
4-purchase type
*company funds
*lease/hir purchase
*rent
and so on........
 
Top