How Do I Auto populate data onto second table?

[Guest]

Hello

I have a data base where the main data entry screen is called "Data Entry"
(original eh!) This table populates a form called "Data Entry"

I have created a new table called tbl_Contract_Production and a form called
frm_Contract_Production I want certain fields (I.E Customer name, application
ID, ETC) prepopulated from the Data Entry Table, with the remainder of the
data to be input by the user. I am sure that this is simple, however I have
been trying for days with no sucess.

Can anyone help me?

 

[John Vinson]

Hello

I have a data base where the main data entry screen is called "Data Entry"
(original eh!) This table populates a form called "Data Entry"

I have created a new table called tbl_Contract_Production and a form called
frm_Contract_Production I want certain fields (I.E Customer name, application
ID, ETC) prepopulated from the Data Entry Table, with the remainder of the
data to be input by the user. I am sure that this is simple, however I have
been trying for days with no sucess.

Can anyone help me?

Stop.

Step back, and think a little about relational database design.

Your customer name should exist in the Customer table - and ONLY in
the customer table. The tbl_Contract_Production should have *LINKS* -
called "foreign keys" - to the Customer table (and perhaps an
Application table), but it should not store information redundantly.

It sounds like you may be making the very common error of jumping to
Forms too soon: you should start with a logical set of Tables, each
with its own Primary Key and relationships defined - and *then* start
thinking about forms to view and edit the data in these tables.
Identify the "Entities" - real-life people, things, or events - of
importance; each type of Entity gets its own table. Once you have
these defined then you can use Forms and Subforms to populate the
tables, and Queries to link them so that you can see (e.g.) a customer
name from tblCustomers in association with Production data from
tbl_Contract_Production.

John W. Vinson[MVP]