Access data Input

[Guest]

How do I input the same information into many records

 

[Rick B]

More details please.

You could use the default value for controls in your form, you could use an
update query, you could use an append query. Lots of options.

Generally, you should not be entering the same information into many
records. This can sometimes be accomplished with a properly designed
relationship between two tables. For example, if you are entering a company
name and address in every invoice record, then you have not designed your
database properly.

Please explain exactly what you are trying to accomplish.

 

[Guest]

I have a data base where information is constantly updating. ie A Po has
many records some are received, I need to enter the date for all items
received. Some items maybe shipped, I have to put in the date shipped for
all items
--
JohnM
Deepwater

More details please.

You could use the default value for controls in your form, you could use an
update query, you could use an append query. Lots of options.

Generally, you should not be entering the same information into many
records. This can sometimes be accomplished with a properly designed
relationship between two tables. For example, if you are entering a company
name and address in every invoice record, then you have not designed your
database properly.

Please explain exactly what you are trying to accomplish.

 

[Rick B]

It seems to me that each item on the PO could ship at a different time.
Same for receive.

If that is not the case, then move those fields out of the PO detail table
and put them as part of the PO summary table. Then it will only be one
entry for the dates per PO, instead of one entry per line item on the PO.

--
Rick B

I have a data base where information is constantly updating. ie A Po has
many records some are received, I need to enter the date for all items
received. Some items maybe shipped, I have to put in the date shipped for
all items

 

[John Vinson]

I have a data base where information is constantly updating. ie A Po has
many records some are received, I need to enter the date for all items
received. Some items maybe shipped, I have to put in the date shipped for
all items

Just to amplify Rick's suggestions, you can also consider running an
Update query with criteria which identify the set of records which
need to be affected.

John W. Vinson[MVP]