A form and two subforms???????

[smelly]

I am very new to access. I am trying to make a form to start a project. I have a CUSTOMER who brings a PROJECT for me and each PROJECT has many SUBPROJECTS. My PROJECT-ID and SUBPROJECT-ID are both autonumbers. I am trying to
1. open the form
2. pick a CUSTOMER from a list box.
3. Push New project button in a subform to increment PROJECT-ID and create a new project for this customer.
4. And have another subform inside my project subform to increment SUBPROJECT-ID to create a new subproject inside my project for this customer.

Its not working at all...any suggestions?
Shall I be going about this in a different manner?

THANK you for any advice/help!!!!!!!!

 

[Fizzio]

Explain a little more why it does not work. Does the New Record button not work? Do the subforms work with existing data? Have you ensured that you have relationships defined between your tables and set the master/child links appropriately between the forms? If you are not sure what I am asking for, let us know.

 

[ColinEssex]

Hi

It is possible that the ID numbers are getting confused?

What you have is

1) a customer
2) a project that belongs to that customer
3) a subproject that also belongs to the customer.

If you have an autonumber for the customer, that should then be the same ID number for the project and the subProject, otherwise I can't see how they link together on the info you've given.

Am I on the right track?

Col

 

[smelly]

THanks for replying.

I will try to explain more. Each form has its own primary key which is an autonumber and I think I have all the relationships set right. THe problems I am having are this...(First problem)On both subforms I have an add new project button that doesn't seem to be working.
I am trying to add a new project with the button but when I click it does nothing. I have the button set to add new record but it doesn't seem to be incrementing the primary key when it is clicked.
Thank you.