Appending records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can someone please advise if it is possible to append a field from a record
in one table to multiple records on another.

Thanks in advance.
 
Can someone please advise if it is possible to append a field from a record
in one table to multiple records on another.
How many records do you want to add to the table when you append these
multiple records? Or do you only want to up some records?
Do these two tables have fields with common data so they may be joined in a
query? If so then join, set criteria and use the [TableName].[FieldName] in
the Update To part of query design view grid. Best thing is to make a backup
first.
 
Karl,

I cannot join the tables at this stage. I will try to explain to you exactly
what I am trying to achieve.

I have two tables 'products ordered' table and 'quotes' table.

Each record in 'products ordered' table contains a product and each record
in the 'quotes' table contains a sales quote.

A quote can contain more than one product.

When we receive an order against a quote we need to add the products listed
in the 'quote' table (bearing in mind that more than 1 products can included
in each record) to 'products ordered' table which involves creating a new
record for each product in the 'products ordered' table. So theoretically we
are converting fields to records.

Can you suggest how this can be done.
--
How1


KARL DEWEY said:
in one table to multiple records on another.
How many records do you want to add to the table when you append these
multiple records? Or do you only want to up some records?
Do these two tables have fields with common data so they may be joined in a
query? If so then join, set criteria and use the [TableName].[FieldName] in
the Update To part of query design view grid. Best thing is to make a backup
first.
--
KARL DEWEY
Build a little - Test a little


How1 said:
Hi,

Can someone please advise if it is possible to append a field from a record
in one table to multiple records on another.

Thanks in advance.
Click to expand...
Click to expand...
 
If the tables have nothing in common then you can not do anything with both
of them at once.
You need to break your 'quote' records into separate records for each product.
--
KARL DEWEY
Build a little - Test a little


How1 said:
Karl,

I cannot join the tables at this stage. I will try to explain to you exactly
what I am trying to achieve.

I have two tables 'products ordered' table and 'quotes' table.

Each record in 'products ordered' table contains a product and each record
in the 'quotes' table contains a sales quote.

A quote can contain more than one product.

When we receive an order against a quote we need to add the products listed
in the 'quote' table (bearing in mind that more than 1 products can included
in each record) to 'products ordered' table which involves creating a new
record for each product in the 'products ordered' table. So theoretically we
are converting fields to records.

Can you suggest how this can be done.
--
How1


KARL DEWEY said:
Can someone please advise if it is possible to append a field from a record
Click to expand...
in one table to multiple records on another.
How many records do you want to add to the table when you append these
multiple records? Or do you only want to up some records?
Do these two tables have fields with common data so they may be joined in a
query? If so then join, set criteria and use the [TableName].[FieldName] in
the Update To part of query design view grid. Best thing is to make a backup
first.
--
KARL DEWEY
Build a little - Test a little


How1 said:
Hi,

Can someone please advise if it is possible to append a field from a record
in one table to multiple records on another.

Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top