Best Method To Update Multiple Tables From A Single Form/Page?

[JungleJme]

Hi,

First of all, thanks to everyone who has helped me so far on this little project i've embarked on as my first ever database. I would not have got as far as i have without the time & knowledge that people have kindly shared with me on this forum

So. My database allows you to log issues (see attached)

An issue will belong to the project, the project may have multiple test plans.

The issue will also be the primary responsibility of a company, and that company may have multiple contacts (people)

Now, i could create a form over the top of each table but then if someone wanted to add a new project, testplans for that project, suppliers (companies) for that project AND new contacts for those companies, they are going to end up going through loads, and loads of forms.

So my question is, what approach would you recommend to create a control panel where they could add these items with the fewest number of page switches possible? (preferably none)

I can see myself chasing my own tail for hours so thought i'd get some advice up front!

Thanks in advance for any thoughts,

J

 

[JungleJme]

OK, well. For now, i'm attempting to create a form where the parent/child relationship between Companies/People and Projects/Testplans is displayed via cascading combo boxes.

The user can manipulate the drop downs and if the item doesn't exist they can click a button which fires a popup form.

I'm going to try and get this pop-up form to create a new record in the appropriate table....

Work in progress at the moment...