filling a field using update query to add redundant data

[Guest]

Hi all,

This is going to sound odd or unuseful. I need to add the same value to a
field to every item in the table. The reason is that I have many parts that
can be repeated for dash number and revision purposes. I have sales orders
that need to lookup all of the revisions for the part. The first parts table
needs to be a running tally of all parts, not of the ones based on sales
order. So is there a way in which I can take user input and then tack it onto
a new table? I used the query to create a new table that will be a temporary
dump table. Once the sales order is added, they will all be appended to a
running tally of sales orders that have been calculated. I know this is
probably very gray in explanation but I tried the update query and using
[Forms]![SO Lookup]![SO] in the update to field, even with the form open
doesn't work.

Thanks in advance!

 

[John Vinson]

Hi all,

This is going to sound odd or unuseful. I need to add the same value to a
field to every item in the table.

An Update query with no criteria will do that in a snap.

The reason is that I have many parts that
can be repeated for dash number and revision purposes.

What's your table structure? What's the primary key? It sounds like
you have a one (part number) to many (revision) relationship which
should involve two tables.

I have sales orders
that need to lookup all of the revisions for the part.

Then the Sales form should have a combo box based on a query selecting
part numbers without regard to revision.

The first parts table
needs to be a running tally of all parts, not of the ones based on sales
order.

Exactly. Parts are one type of entity; Sales are a different type of
entity, related to the Parts table but having its own existance.
Therefore they should - must! - have separate tables.

So is there a way in which I can take user input and then tack it onto
a new table? I used the query to create a new table that will be a temporary
dump table. Once the sales order is added, they will all be appended to a
running tally of sales orders that have been calculated. I know this is
probably very gray in explanation but I tried the update query and using
[Forms]![SO Lookup]![SO] in the update to field, even with the form open
doesn't work.

Now you have COMPLETELY lost me.

You should have a table of Parts. There will almost certainly need to
be a data entry form to update this table.

Your Sales will use a separate sales table, and a separate form. No
"temporary dump table" would seem to be either needed or appropriate!

What tables do you currently have? How are they related? How are you
entering data into these tables?

John W. Vinson[MVP]

 

[Guest]

I have solved my issue (due to a lack of communication from my boss). I only
needed to pull data from one place, then pull more data from a table already
in the database based upon what was in the import. Thanks for trying to help

Hi all,

This is going to sound odd or unuseful. I need to add the same value to a
field to every item in the table.

An Update query with no criteria will do that in a snap.

The reason is that I have many parts that
can be repeated for dash number and revision purposes.

What's your table structure? What's the primary key? It sounds like
you have a one (part number) to many (revision) relationship which
should involve two tables.

I have sales orders
that need to lookup all of the revisions for the part.

Then the Sales form should have a combo box based on a query selecting
part numbers without regard to revision.

The first parts table
needs to be a running tally of all parts, not of the ones based on sales
order.

Exactly. Parts are one type of entity; Sales are a different type of
entity, related to the Parts table but having its own existance.
Therefore they should - must! - have separate tables.

So is there a way in which I can take user input and then tack it onto
a new table? I used the query to create a new table that will be a temporary
dump table. Once the sales order is added, they will all be appended to a
running tally of sales orders that have been calculated. I know this is
probably very gray in explanation but I tried the update query and using
[Forms]![SO Lookup]![SO] in the update to field, even with the form open
doesn't work.

Now you have COMPLETELY lost me.

You should have a table of Parts. There will almost certainly need to
be a data entry form to update this table.

Your Sales will use a separate sales table, and a separate form. No
"temporary dump table" would seem to be either needed or appropriate!

What tables do you currently have? How are they related? How are you
entering data into these tables?

John W. Vinson[MVP]