Hi I am having trouble with my database and I think it stems from the way that I have set up the tables and relationships.
The problem I am having is that I split my clients into two types - private and company clients.
However I am now stuck as to how to query both sets of data. I want the user to be able to search the database by Card Number or by Name and to search both sets of data and then open the form relating to Private or Company depending on the type of client.
I can do this for each one seperately but cannot for the life of me understand how to combine it.
I feel that another problem is that a Card Number should be in a seperate table as each card issued needs to be unique and I can't do this when it is split into two tables.
I have put a screen shot of the relationships up, does anyone have any suggestions how I can bring these two sets of data together, or do I need to redesign?
The problem I am having is that I split my clients into two types - private and company clients.
However I am now stuck as to how to query both sets of data. I want the user to be able to search the database by Card Number or by Name and to search both sets of data and then open the form relating to Private or Company depending on the type of client.
I can do this for each one seperately but cannot for the life of me understand how to combine it.
I feel that another problem is that a Card Number should be in a seperate table as each card issued needs to be unique and I can't do this when it is split into two tables.
I have put a screen shot of the relationships up, does anyone have any suggestions how I can bring these two sets of data together, or do I need to redesign?
