I am a newbie to Access and learning the same.
I am stuck in a problem and not able to get through. Please advice
I have made tables as below but am not able to get through the relationships an form for input of data
tblcustomers
- CustomerID - Autonumber - PK
- CustomerType
- BoutiqueType
- Customer Zone
- Customer Number
- Company
- FirstName
- LastName
- Phone1
- Phone2
- Fax
- Mobile
- Email
- notes
tbladdresstype
- Addresstype (eg: Billing, shipping, office, factory, godown, residence etc.)
tblcustomeraddress
- Street
- City
- Pin
- State
- Country
- Phone
- Fax
Now I want to have multiple address for each customer. Please let me know what all the fields to link in relationship and what type of relationship.
What fields to include on form frmCustomerDetails.
Thanks in advance
I am stuck in a problem and not able to get through. Please advice
I have made tables as below but am not able to get through the relationships an form for input of data
tblcustomers
- CustomerID - Autonumber - PK
- CustomerType
- BoutiqueType
- Customer Zone
- Customer Number
- Company
- FirstName
- LastName
- Phone1
- Phone2
- Fax
- Mobile
- notes
tbladdresstype
- Addresstype (eg: Billing, shipping, office, factory, godown, residence etc.)
tblcustomeraddress
- Street
- City
- Pin
- State
- Country
- Phone
- Fax
Now I want to have multiple address for each customer. Please let me know what all the fields to link in relationship and what type of relationship.
What fields to include on form frmCustomerDetails.
Thanks in advance