Pulling data from one onto another table

[Guest]

I am kind of new at this - I have one table that has customer information,
another table that stores p/n's and another one that stores a list of our
customers. I created a query table, (customer service source info), pulling
fields from different tables to create my form for customer service to enter
information onto. I then created a table that has corrective action info on
it. I created another query table, (corrective action source), to pull
fields from my corrective action table and customer service query table to
create my corrective action form for employees to enter info. I wanted some
information to automatically transfer over onto my corrective action source
query table from my customer service query table. I used fields from both
tables to create my new one, then I linked the two tables primary key
field's.

This seemed to work, except I cannot add any info onto my newly created
query table. When I add info onto my customer service source query table, I
see that info in my new corrective action source query table however, I try
to add info into the rest of the fields, that the source table is my
corrective action table, and Access won't let me type any info onto the rest
of my fields. I do not understand why. I know I typed a lot of info here,
but I'm hopeing I conveyed my information in a way that someone will
understand.

I am assuming there is an easy fix for this and I sure wish I knew it.

Thanks ahead of time for anybody's help on this.

 

[John Vinson]

I am kind of new at this - I have one table that has customer information,
another table that stores p/n's and another one that stores a list of our
customers.

You CERTAINLY need more tables... and perhaps fewer.

The list of customers and the table of customer information SOUND from
the titles like they should be combined into one table, wherein each
record is a customer. What is the "customer information"? What are
some typical fields?

I created a query table, (customer service source info),

Ummm... There is no such thing as a "query table". A Table is a data
repository; a Query is a tool for selecting and combining data from
Tables.

pulling
fields from different tables to create my form for customer service to enter
information onto.

And that may not be the best idea either. If you have two tables in a
one to many relationship, it's usually simplest to base a Form on the
"One" table, and a Subform on the "many".

I then created a table that has corrective action info on
it. I created another query table, (corrective action source), to pull
fields from my corrective action table and customer service query table to
create my corrective action form for employees to enter info.

Clearly *you* know how Customers, and Customer Information, and p/n's
(whatever they are) are related to "corrective actions", but nobody
here does. Could you describe the structure of your Tables, with a bit
of explanation about what these entities might be? I'm really rather
lost!

I wanted some
information to automatically transfer over onto my corrective action source
query table from my customer service query table. I used fields from both
tables to create my new one, then I linked the two tables primary key
field's.

That's almost certainly WRONG. The primary key of a table uniquely
identifies one record. It would be very unusual (a One to One
relationship) to have the Primary Key of one table linked to the
Primary Key of another table.

This seemed to work, except I cannot add any info onto my newly created
query table. When I add info onto my customer service source query table, I
see that info in my new corrective action source query table however, I try
to add info into the rest of the fields, that the source table is my
corrective action table, and Access won't let me type any info onto the rest
of my fields. I do not understand why. I know I typed a lot of info here,
but I'm hopeing I conveyed my information in a way that someone will
understand.

Please open this Query in SQL view (use the View menu option) and post
the SQL text here, together with - as I said - some description of
these tables. It's particulary helpful to indicate the name and
datatype of the Primary Key fields, and specify how (if at all) the
tables are related in the Relationships window.

I am assuming there is an easy fix for this and I sure wish I knew it.

Thanks ahead of time for anybody's help on this.

John W. Vinson[MVP]