how to make relationship?

[Guest]

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.

 

[Joseph Meehan]

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.

What would you like it to show?

Could you give us a partial list of the fields in those tables. Just
the ones that might be involved in forming the relationships.

 

[Guest]

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........

 

[Joseph Meehan]

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)

Forget all that.

*previous employee
Start Date
End Date

I assume the following are linked to other tables:

-employee name(text)
-designation(text)
-department(text)

add
Purchase type??

3-total cost
*base price
*shipping & handling costs
*taxes / duties paid
*total cost
*budget expense
-expense type
-quantity
*first year value

I assume the above has links to table 1?