New Record from an Existing one

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: achett (achett_at_discussions.microsoft.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 10:19:02 -0800

Hello
I'd appreciate if someone can direct me to how I would go about creating a
new record from an existing one. I would like to make changes accordingly to
the new record and save it.

I created a query from my 2 tables
Ist Table: JobEvent
Primary key-Job eventID Autonumber (field1)
Job Type Number (field2)
2nd Table: Job Type (field1)
Primary key- Job Type ID Auto number
I linked these 2 tables using the Job Type ID and created a Query
The form is based on the query.

Any help is greatly appreciated.

achett

Relevant Pages

  • Re: Fields calculated from different table
    ... It is almost always better to use a query for this type of thing. ... GROUP BY [Job Type] ... -- Change Group By to Avg under Hours ...
    (microsoft.public.access.queries)
  • Create a new record from an existing one
    ... I have 2 tables that are linked to create a query. ... Fields: Job Type ID ... Job Event ID(Primary Key, Autonumber) ...
    (microsoft.public.access.forms)
  • Re: Create a new record from an existing one
    ... "achett" wrote in message ... > I have 2 tables that are linked to create a query. ... Job Event ID ... I have the Job Type ID selected from Job Events Table ...
    (microsoft.public.access.forms)
  • Re: Tables and a form
    ... Allan Murphy ... > The form is based on the query from the above 2 tables. ... > combobox (Job Type ID) whose row source is the query. ...
    (microsoft.public.access.forms)
  • SELECT QUESTION
    ... Table1 contains two fields. ... Field1 contains Unit ... table2 for the job type that matches in both tables. ... doctors. ...
    (comp.databases.ms-sqlserver)