Recent content by mking

Ok ninja edit: I took out the date/time out of the customer table and put them into the visit table and the visit table alone. I added CustID to the Visit table and created a lookup from Visit to Customer, and Visit to Salesman things are starting to take shape I must say, thank you for all...

I used the lookup option for the salesmanID, should I be using it as well for the customerID and the date as well?

Even creating the field VisitID and making it the PK it still only allows for intermediate and 1:1 All itll let me open is the replica, I can try zipping the entire folder and seeing if you could open it that way.

Yeah, here it is

Well try as I might access will only allow me to create a 1:1 or an intermediate relationship from tblVisits to tblSalesman no matter what fields I try to use.

Oh, that looks good, however; the other thing I'm needing to see is that when a salesman has a customer so you can see what customer was dealt with. 1 customer can have many salesman 1 salesman has many customers customers can have many dates dates have many customers Does this make sense or...

didn't see the attachment

Ok I made the changes like you said replacing the fields. Now my question is how to relate the fields making them now multiple 1 to 1 relationships?

Currently this is how I have it setup tblCustomerInfo ID Autonumber Prefix FName LName Suffix Street City State Zip Phone DateVisit TimeVisit Description SalesmanName Uptype tblVisit DateVisited TimeVisited TypeVisit SalesmanName tblSalesman ID SalesmanName SalesmanNumber (PK)

Well I'm pretty rusty on the concepts of many to many relationships, but I'm assuming thats what I want to create for this situation. What I'm creating is a database to track customers that enter my place of buisness. So far so good, but what I'm having issues with is 2 of the major things that...