address.mdb needed

[Ron]

Hi who can help me

in my database I have a table containing records of clients
I want to split it into 2 tables, one table storing companydetails and one
table storing employees. The companies have to be connected to the
employees and employees to the companies in this way that when I click on a
company all employees of that specific company are shown. Also when I click
on a employee the company will be displayed
I tried to find out in Northwind but that is different

Think there are ready-made solutions for it.

Thanks in advance
Ron

 

[Rick B]

This is a classic one-to-many relationship.

First, get your data split into two tables.

In the employee table, you will need to add a field that connects to the
company table. Do the company records have a unique id, like an account
number?

In your employee table design view you can add the company reference field
and change the type to lookup wizard. it will pretty much walk you through
linking the table.

Northwinds should have very good examples of this in that it has invoices
(one) and invoice detail lines (many).

Post back as you run into specific questions.

Rick B


Hi who can help me

in my database I have a table containing records of clients
I want to split it into 2 tables, one table storing companydetails and one
table storing employees. The companies have to be connected to the
employees and employees to the companies in this way that when I click on a
company all employees of that specific company are shown. Also when I click
on a employee the company will be displayed
I tried to find out in Northwind but that is different

Think there are ready-made solutions for it.

Thanks in advance
Ron

 

[Ron]

Thanks Rick
What I need is when I click a company on a form it has to show the data
of that company and all the employees, when I click on a specific employee
it shows all data of that employee and want to use the details of that
employee in a report or another form (look-up??)

bstrgrds
Ron

 

[Rick B]

That is possible. But you have to build the base first. You are talking
about the carpetting, and you have not even poured your slab yet. We can
get to that after you get the basics built. That is why I said to post back
as you run into specific questions.


Rick B


Thanks Rick
What I need is when I click a company on a form it has to show the data
of that company and all the employees, when I click on a specific employee
it shows all data of that employee and want to use the details of that
employee in a report or another form (look-up??)

bstrgrds
Ron