I had a similar problem. I tried the above method but after the first order, all other orders had the same order id....does anybody have an idea of how to solve this?
I forgot something.
The ID for the new table when appended into the Product Details table should start with a 4 digit ID as well.
For example: If the last record in the Product Details table was
Product ID Product Name
5551 Shoes
The first entry in the other table should be...
Hi,
I'm not an expert at MS Access at all. But I need some coding or help because I'm in a bind right now.
Here's the situation: I have a Product Details table, and I want to append another table to this table. But the Product Details table has a ProductID that is a 4 digit number while the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.