Creating SubForm for Data Entry

[Jamsandwich]

Hey guys,

I feel like this ought to be simple, but I'm kind of struggling. Can't seem to find a good tutorial.

I currently have a form for creating new projects. I'd now like to add extra functionality to that form. I want to be able to add in project roles with a person's name and hours required. The roles aren't defined yet, but I'd like to start by allowing user to input the roles themselves. Or, perhaps, add to a drop-down from the box (if possible).

I've created a roles Table. I don't know how to carry on from there.

I'm guessing it's necessary to link the primary key from projects table to the roles table right?

---Edit for clarity---

One project may have many roles attached. It is possible to have same role more than once with different people.

 

[synergy16]

I think I can help you, but I need a lot more information. your request is very vague.

 

[Jamsandwich]

Ah, it's ok now.

I was putting a form together so I could show you the kind of thing I'm working with and I actually managed to figure it out. I hadn't set up the one-to-many relationship properly.

Sorry to waste your time, but thank you very much for the offer of help Synergy

 

[synergy16]

lol, no problem. I cant tell you how many times I posted on here and right after I did I figured it out!!