How to choose a record on a subform

[Guest]

I want to pick a record on a subform. This is what I have...
Table Events(EventID as Primary, EventName etc.)
Table EventEmployees(EventEmployeeID as Primary, EventID as foreign,
EmployeeID as foreign, Comments as memo)
Table Employees(EmployeeID as Primary, Name, address, etc.)
Table EmployeePosition(EmployeePositionID as Primary, EmployeeID as foreign,
PositionID as foreign, Comments as memo)
Table Positions(PositionID as primary, PositionName)

My question is, how can I choose a position for a specific event.
Example:
Event=Party1
Employee1=John(Waiter, busser, Bartender)
Employee2=Peter(Bartender, Cashier)
For the Event I need a waiter and a Bartender, so on my form I want to have
a subform to be able to choose John as a Waiter and Peter as a Bartender.

I hope this is not to confusing to understand. Is this posible just with
Form and Subform or do I need to use Visual Basic?

Thanks
Carlos

 

[Guest]

Why not just add a combo box to your subform that selects PositionID,
PositionName from table Positions. Column count = 2, column widths = 0,2

HTH