Please... Help

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

Nad

Hi Gentlemen,
I have two tables namely tblApprovedProjects and tblProjectDetails with One
to One relation.
ApprovedProjects fields are : SlNo, ProjectName, Priority, Client, Budget
,Start Date.
ProjectDetails fields are : SlNo, ProjectName, Priority, Client, Budget,
ProjectNumber, EngineerName, ProjectPhase, Status, PlanFinshDate …etc.
I have two separate forms to update these tables. The ApprovedProject form
is with me to update and the other form ProjectDetails will be with engineers
to update.
What I want is that, If I add new approved projects it should also add the
common fields in the ProjectDetails table and form so that engineers will
update the rest information.
Thanks in advance for your help.
Regards,
 
Use the AfterInsert event procedure of the form where to enter the projects.

In the code, Execute an Append query statement to insert the values into the
related table.

If you're not sure what the query statement should look like:
- mock one up by typing any literal values into the Field row in query
design,
- change it to an Append query (Query menu or ribbon),
- map the fields the values are to go to,
- switch the query to SQL View, and
- build a SQL string that looks like that.

If Execute is new, here's an example:
http://allenbrowne.com/ser-60.html
 
Hi Gentlemen,
I have two tables namely tblApprovedProjects and tblProjectDetails with One
to One relation.
ApprovedProjects fields are : SlNo, ProjectName, Priority, Client, Budget
,Start Date.
ProjectDetails fields are : SlNo, ProjectName, Priority, Client, Budget,
ProjectNumber, EngineerName, ProjectPhase, Status, PlanFinshDate …etc.
I have two separate forms to update these tables. The ApprovedProject form
is with me to update and the other form ProjectDetails will be with engineers
to update.
What I want is that, If I add new approved projects it should also add the
common fields  in the ProjectDetails table and form so that engineers will
update the rest information.
Thanks in advance for your help.
Regards,

Why 2 tables with (partly) the same data?
You could make 2 forms to update the same table.

Groeten,

Peter
http://access.xps350.com
 
Many Thanks Gentlemen. I got the solution.

Another problem!
The users are updating this database monthly.
I want to make monthly report and for this i have to keep every month
changes but unable to do this as users are changing the same table every
month. i don't know how to do this?
Plz help.
 
Many Thanks Gentlemen. I got the solution.

Another problem!
The users are updating this database monthly.
I want to make monthly report and for this i have to keep every month
changes but unable to do this as users are changing the same table every
month. i don't know how to do this?
Plz help.

First you must decide on which data you want to report monthly. I gues
the project name or client doesn't change every month.

Data that you want to track (like status?), you put in an separate
table. Fileds in this table are all data you want to track, plus
projectID (SINo) and year/month. There is an 1 to many relation
between the project table and the new table.

Groeten,

Peter
http://access.xps350.com
 
If you must keep a copy of the report's data exactly as it was when the
report was printed (regardless of any additions, edits, or deletions for
that month made since), then you will need another set of tables to hold
this data. Use an Append query to populate the tables for the report month.
And base the report on these tables, not the current ones.
 
Back
Top