Re: 2 contacts = 1 client
Here is the question: "Made of two contacts." How do you mean that? Your description is a very simple statement that condenses your meaning a bit TOO much.
My thought here is that you need to search for some topics using this forum's search function, which is 3rd from the right in the ribbon near the top of the page just under the little box that tells who you are.
Topic #1 - database normalization - with the end goal of learning about many-to-one relationships and one-to-many relationships.
Topic #2 - business model - with the end goal of learning about how to better make your database a "map of the territory" so to speak.
Topic #3 - junction tables - with the end goal of learning how to manage what we call a "many to many" relationship. For instance, if the same contact can lead to two orders and (as you state is your problem) an order can originate from two contacts, then you have a many-to-many relationship.
OK, having made the suggestions, I SUSPECT that your problem is that your contact info is in the same record with the order info and you don't have two contact slots in that record. IF that is correct, you need a separate contact list. Probably need a separate client list if you have repeat business, too.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.