newbie question: Multiples of records from 1 table to another

  • Thread starter Thread starter Ian D. Weatherall
  • Start date Start date
I

Ian D. Weatherall

Hello,
I have 2 tables:

Positions
position code
position
epk code

epk core modules
module code
module

Each position has many module codes

For 1 record in position how do i add multiple module codes?

For example:

Position record 1=cashier

Cashier needs to complete epk code 1,2,5&7

I hope my question is clear enough?

Regards,

Ian
 
Ian

If you are saying that one Position could have many "epk codes", your table
structure does not reflect this.

If you have a many-to-many situation (one position, many epk codes, and one
epk code, many positions), you need three tables to handle that relationship
alone:

tblPosition
PositionID
PositionDescription
...

tblEPKCode
EPKCodeID
EPKCodeTitle
...

trelPositionEPKCode
PositionEPKCodeID
PositionID
EPKCodeID

I don't have enough information to hazard a guess how "epk core modules" are
related to these three...
 
Thanks Jeff,
The many-to-many scenario you describe is correct.
Now I just need to get it to work.
Regards,
Ian
 
Thanks again Jeff,
I have creted the table and set up the relatioships, but how do I creat the
form to setup the links.
1 position will have a number of modules linked to it.
Regards,
Ian
 
Ian

A one-to-many relationship can be managed with a main form/subform design.
The main form will hold the "one" side, the subform will hold the "many."
The subform is linked to the main form by the field(s) they have in common
(usually the "one" table's primary key, showing up as a foreign key in the
"many").
 
Back
Top