Adding more records to a record

[pascaly]

Hi,

I've tried to search around for a solution to this as I won't be the first to have asked about it, but I cannot think of a term to clearly define it and what I have searched for doesn't come up with what I'm looking for.

We have a Db that holds data on multiple projects (Project A, Project B etc), then each project has some basics (start date, cost etc). Where I am stuck is, each project also has Resources, which are people working on the project. Each project has multiple Resources and they are different from project to project. Also, some projects might have 2 Resources while another may have 20 or more.

What I'd like help with is how to I store these Resources? I obviously don't want to have multiple fields (Resource1, Resource2 etc) as I don't know how many I will need for each project (they get added as the project continues), so how could I solve that? How can I expand my data if it's in the same field?

Thanks

 

[HiTechCoach]

I do this by using a child table that has one record per resource item. It would be the many side of a 1 to many relationship. This is just like the detail records of an imvoice.

I would use a sub form to display the data

 

[pascaly]

Thanks Coach,

that sounds good. Plus the sub-form part is useful, a datasheet view would be perfect for the data I have.

Thanks for your help, much appreciated.