Windows Vista 
Access 2007
I am hoping that this will not be too vague.
Over two years ago, I created a database to track sales. I am using a form to enter the data. I linked the customer table to the order table so that when I opened the order form, all I needed to do was type the customer order number in the correct field and the rest of the customer information would auto-populate from the order form. It was perfect, and allowed me to only add specific orders to the database, as needed.
Recently something has changed - and I cannot remember making any changes to anything. Now, every time I add a new customer to the customer form, it adds a corresponding order to the order form. I only track specific orders using this database and now I am forced to track every order from every customer.
The only relationship is a one to many relationship for the customer order where the "one" is the customer table and the "many" is the orders table.
Any ideas where to look?
Reply With Quote
