Any Idea's please?

[Guest]

I am building a Database to track customers and currently have 2 Tables for
Customer information. The reason for 2 Tables is that the customers fall into
2 catagories, General customers with one branch and 1 customer with nearly
1000 branches. The single large customer has many more Fields that the
General Customers but that would not present much of a problem.
Amongst others, I use the Customer name as a search Combo and if I put the 2
tables into 1 (preferable), I would be presenting the operator with not only
a large selection of all the different customer names but also nearly 1000
possible selections of all the branches of the 1 customer Name(all of which
would be the same name. Is there any way I could make the Combo box selective
so that it would only show only the customers with 1 Branch?. I could work it
the other way by hiding the Custome Name Combo and displaying a "Branch Name
Combo" when the I customer with many branches is selected from a "Radar"
button ore something Like that.

Any thoughts please?
thanks RayC

 

[Guest]

sA customer is a customer is a customer. Information on the customer, such as
name, address, phone number, etc., should be in one Customer table. All the
Branches should be in a Branch table and linked to the Customer table.
Further the Branches should not go across the table in different field.
Rather they should go down like:

CustNo BranchNo
1 1
2 2
3 3
3 4
3 5

Question: What happens in one of your other customers buys another branch?

I highly suggest getting some relational database training or reading
"Database Design for Mere Mortals" by Hernandez before proceeding any further
on this database.

 

[Guest]

Ok Jerry, I hear what you say and will look at re designing my 2existing
tables in the way you suggest. Thank you for your valued advice

Rayc