Follow-Up to previous post...

[InQuery2004]

Greetings,

I am just posting a follow-up on my previous post on designing functional forms. Telling by the lack of replies, my original question may have been long winded and tedious. Let me try to narrow my question and make it more concise.

In two tables connected by a one-one field name ProfileID, how can I set a new field in the second table (call it StepNo or procedureNo) so that it increments step numbers for each unique ProfileID record? Thus for each new Profile record created in the first table, a new form will allow the entry of X numbers of steps into the second table and automatically link the two records?

I hope that clarifies my problem. Thanks in advance.

 

[ecniv]

Do you mean as you create the top record from one form a set number of linked records are created?

Use VBA code as you save the top form. I guess since you are posting this you've used a bound form. This may complicate matters slightly, but you should be able to still use code to create the required records. Which then leaves you to have a pop up form and editting only on it for the sub records.

 

[Pat Hartman]

I'm sure there are hundreds of posts here since this is one of the most common questions. Search for Max and autonumber.

 

[InQuery2004]

My VBA programming is quite pathetic and as important as it is in Access programming, I don't yet have the time to build a competency in this important language.

Having said that, I will definitely search for topics under the suggested areas. Thanks for the information guys.

Cheers,

Mike J.