N
Noemi
We have a form which requires a new record to be added to our database each
time certain fields are completed however the majority of the detials entered
on the form need to be repeated for each requirement.
Is there are simpler code to use using doing the .AddNew for 6 different
requirements but with the same detail.
example:
we have an order system which generates multiple orders depending on the
type of product being ordered and then whether there are multiple locations.
lets say we have an order for multiple products at Bourke Street however the
order is coming from multiple locations but all locations are supplying the
same products. We want to be able to record each product against each
location in one table under a column for products and a column for locations
so if we need to do a query we have all details in one database, but the
remainder of the details entered onto the form need to be the same against
each product with each location.
I hope this makes sense.
Thank you for your help in advance.
time certain fields are completed however the majority of the detials entered
on the form need to be repeated for each requirement.
Is there are simpler code to use using doing the .AddNew for 6 different
requirements but with the same detail.
example:
we have an order system which generates multiple orders depending on the
type of product being ordered and then whether there are multiple locations.
lets say we have an order for multiple products at Bourke Street however the
order is coming from multiple locations but all locations are supplying the
same products. We want to be able to record each product against each
location in one table under a column for products and a column for locations
so if we need to do a query we have all details in one database, but the
remainder of the details entered onto the form need to be the same against
each product with each location.
I hope this makes sense.
Thank you for your help in advance.