Add Record two table

[Nad]

Hi Guys,
I have a common field (ProjectNumber) in two table.Between table there is
one to many relationship.
I have a form to add new ProjectNumber with other information.
What i want is that, when i add new projectNumber it should add to both the
table.

Thanks & Regards

 

[Jeanette Cunningham]

Hi Nad,

The correct process is for a ProjectNumber to be added to only the Project
table when a new project is added.

A common way to set this up is to have the main form bound to the table on
the one side of the relationship and the subform bound to the table on the
many side of the relationship.

To add new projects, a new project is added to the main form, to add details
for this new project to the other table, the subform is used. The subform
will use the new ProjectNumber from the main form and add the projectNumber
to the second table when you enter the data in the subform.

Post back if we can help with setting up your main form and subform.

Jeanette Cunningham

 

[Nad]

Thanks for your quick reply.
I m going to check.

Hi Nad,

The correct process is for a ProjectNumber to be added to only the Project
table when a new project is added.

A common way to set this up is to have the main form bound to the table on
the one side of the relationship and the subform bound to the table on the
many side of the relationship.

To add new projects, a new project is added to the main form, to add details
for this new project to the other table, the subform is used. The subform
will use the new ProjectNumber from the main form and add the projectNumber
to the second table when you enter the data in the subform.

Post back if we can help with setting up your main form and subform.

Jeanette Cunningham

 

[Nad]

Thank U very much Jeanette.I got the solution.
I have other question regarding form size.
Actually, i split my database and distribute the frontend to the different
user.
Since different user are using the different size of the screen, so i want
that my form fit to the screen according to the screen size.
Thanks again
Regards

 

[Jeanette Cunningham]

Nad,

The easiest way to do this is to make your form small enough to fit the
screen for the user who has the smallest screen space, then it will always
fit the screen for all users. It is possible to get software that resizes
your forms, if I remember correctly Peters software has a resizer for Access
and I think there would be others as well. If you want to write your own
code, see the example databases that come with the book by John Viescas
'Building Microsoft Access Applications'.

Jeanette Cunningham

 

[Jeanette Cunningham]

Nad,

The easiest way to do this is to make your form small enough to fit the
screen for the user who has the smallest screen space, then it will always
fit the screen for all users. It is possible to get software that resizes
your forms, if I remember correctly Peters software has a resizer for Access
and I think there would be others as well. If you want to write your own
code, see the example databases that come with the book by John Viescas
'Building Microsoft Access Applications'.

Jeanette Cunningham