Search results

I’ve been trying to hash out the following problem for a while, but I think there is some fundamental concept I’m not getting. I am creating the attached database to manage various projects a certain organization is funding. One project may take place in more than one city, have more than...

Mil-o-Phile, For the past week I've been playing around with the suggestion you gave me and I have to admit that I'm lost or maybe just way over my head. I now have subforms which don't correspond with the main form. Could you please elaborate? Also, I should probably make clear that the...

Advice from both of you has been very useful to me, but everythings not worked out yet. We're on holiday until Thursday... I'm going to do some reading and experimenting in between. Mile-o-Phile, I know I've taken up a lot of your time, but I already know that I'm going to need some more...

Mile-o-Phile, Are you suggesting that I make many-to-many relationships between the various sub-tables (categories, cities and considerations)?

Ken, What do you mean by project level flds??? I'm sorry, but could you talk to me as if I were blonde cuz I'm really new at this

I was told to use do so by two people in another forum. All the information in the project table only has one answer to each project (e.g. each project has only one title, termination date, etc.). The project ID is what I use to link (1 to many) to the tables where there are several answers...

Thanks for the advise guys... I re-did the form and subforms as Ken suggested and it worked!! :) But, the queries and reports still come up with duplicate entries :mad: Any ideas???

Ken, Thanks for replying so quickly... I used the wizard to create the form with tblProjects as the main form and the other tables as the subforms... is tha incorrect? Should I have done it manually?

I desperately need someone's help with the following problem: BACKGROUND: I am creating a database to manage information about various projects a certain organization is/will be funding. I have set up my tables with 1 to many relationships as one project may have many characteristics (i.e...