Hi All!
I'm building a database that a customer would be updating via a form. This is for a pet sitting service, so I may have 1 or many co-owners of a pet, therefore one or many individuals for each Customer Account. Also, each individual may have 1 or many customer accounts.
I have the following tables
Customer Table which holds CustID (PK), Address, City, etc...
Individuals Table which has specific information about each individual: IndID (PK), MobilePhone, TextPreferences, etc
CustomerIndJunction Table (Junction table because Customer has many to many relationship with Individuals): CustID (PK/FK), IndID(PK/FK)
I am familiar with the concept that I need a master form (Customer) and a sub-form (CustomerIndJunction) to be able to tie Customer to Individuals through the Junction Table Relationship, however the most common way it seems this is done is to have a combo box or list box tied to the Individuals Table (IndID) to allow choice of one of those to be assigned as the value of IndID located in the Junction table.
The problem this presents, is I don't want each customer to be able to pull down a combo box and be able to view all the individuals contained in the individual table (all the individuals that are also customers) as this is non of their business.
I've searched diligently but haven't really been able to come up with a good idea on how to handle this and I'm really stumped.
Additional requirements that throw a kink in possible solutions is that I hope to web-enable the database, integrate it with a website, and build forms on the ipad and android to be able to interface with the database, so anything I do, I'm trying to figure out if it's compatible with these plans as well.
Thanks in advance for your time and any thoughts you may have!
I'm building a database that a customer would be updating via a form. This is for a pet sitting service, so I may have 1 or many co-owners of a pet, therefore one or many individuals for each Customer Account. Also, each individual may have 1 or many customer accounts.
I have the following tables
Customer Table which holds CustID (PK), Address, City, etc...
Individuals Table which has specific information about each individual: IndID (PK), MobilePhone, TextPreferences, etc
CustomerIndJunction Table (Junction table because Customer has many to many relationship with Individuals): CustID (PK/FK), IndID(PK/FK)
I am familiar with the concept that I need a master form (Customer) and a sub-form (CustomerIndJunction) to be able to tie Customer to Individuals through the Junction Table Relationship, however the most common way it seems this is done is to have a combo box or list box tied to the Individuals Table (IndID) to allow choice of one of those to be assigned as the value of IndID located in the Junction table.
The problem this presents, is I don't want each customer to be able to pull down a combo box and be able to view all the individuals contained in the individual table (all the individuals that are also customers) as this is non of their business.
I've searched diligently but haven't really been able to come up with a good idea on how to handle this and I'm really stumped.
Additional requirements that throw a kink in possible solutions is that I hope to web-enable the database, integrate it with a website, and build forms on the ipad and android to be able to interface with the database, so anything I do, I'm trying to figure out if it's compatible with these plans as well.
Thanks in advance for your time and any thoughts you may have!