Add Record two table

  • Thread starter Thread starter Nad
  • Start date Start date
N

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
 
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
 
Thanks for your quick reply.
I m going to check.

Jeanette Cunningham said:
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
Click to expand...
 
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
 
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
 
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
 
Back
Top