Out of range error when creating a form

[marcvanderpeet12]

Dear all,



I have the following table (see attachment for an overview of the relationship)

Table Division

1. DivisionID (primary key)
DivisionName

Table employee Division

2. EmployeeID (primary key)
DivisionName

Table employee Name

3. EmployeeID (primary key)
EmployeeName

&

table employee star

4. EmployeeID
StarID

I linked all the tables but i cant get an overview with DivisionName, EmployeeName & StarID. Anybody some clues on how i can solve this?

Regards, Marc

[June7]

Why do you have an Employee_Division table? Can each employee associate with more than one division?

Did you intentionally use a name of Divisie_ID? What is a divisie?

Why do you nee a make table action?