I am a novice creating my first database for a company and i would really appreciate some help.
I have a tabbed form which has fields from multiple tables on it. I have a combo box which allows me to search a clients ID and it brings up all the information for that client from multiple tables e.g their name from an information table, their address from an address table and their investments from an investment table. This is done through linking the tables through a one to many relationship by the clients ID all from the information table eg. Info table(one) - Address table(many) and Info table(one) - Invesment table(many) . However some clients may not have any investments and therefore does not have a client ID in the investment table, this is where the problem occurs, when i try to search for the clients which do not have any investments the combo box does not even populate the fields from the information table such as the name. I have found out that i would need to have the clients ID in the invesments table even if the other fields aren't populated just to get the information fields in the form populating. Is there a way round this?
Any tips or advice would truly be appreciated as i have spent many days trying to get round this problem.
Kelly