WOW! that worked. I can't tell you how much i appreciate your help. it's just so frustrating sometime b/c I know ANYTHING is possible, it's just a matter of knowing how to do it.
thanks for showing me the way.
if you could explain here, i'd appreciate it.
it seems easier than having to re-explain my db to someone else.
if this is too much to ask, i'll make my way over there.
Wow, looks great
thank you for the response. the set-up looks great. I have set up the tables are you suggested, and it looks like they will work great. I do have a question regarding the Form to assign several contacts to one project.
The table is set up as
tableProject_Link
contactID...
first thing's first... i've never set up a Access db. I have, however, worked with php/mysql so I understand dbs and the basic principles behind them.
i was hoping you could help me set up my db to accomplish my goals now and help me in the future when i want to make this system more advanced...