J
JohnM
How do I input the same information into many records
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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.
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.
J
JohnM
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
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
Rick B said: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.
R
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
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
JohnM said: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
J
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]