Access statemet.

[assad12]

Hi,

Im an employee at Solihul college, and currently building a database for the sales dept.

I have created most of my relationships and tables.

the problem i have is:

Many courses can be booked by a comapny for many employees at a time.

on the booking form. i will insert many employees can join many courses. How will i go about getting that statement read on my ERD diagram.

the tables i am currently using are:

Company, employees, courses, bookings, customer bookings.

Thanx!!

Assad

 

[Darrylles]

Hi,

[tt]
tblCompany tblEmployee
---> pk <------ pk <----
| Name | Name |
| |---->> Company_fk |
| |
| |
| |
| tblGroup |
| pk |
| Group_Name(Course?) |
|----->> Company_fk |
Employee_fk <<---------------|

[/tt]

This help?

Regards,

Darrylle &quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot; darrylles@totalise.co.uk