Help needed with table design

[beanie_d83]

Hi all,

I am aiming to create a database that will help me record any warranty issues/claims that might occur with the products we manufacture.

We sell products to various different dealers and most of these dealers have more than just 1 branch/depot and will also have a 'head office'.

What I want to do is store all of these dealer branches along with their details so I can pick them from a drop down list in a form. My question is, do I need to create 1 table with all of our dealer head office details in and then link this to a second table with all other branch details? Alternatively, do I just put them all in a single table?

I hope this makes sense, please forgive the fact that I am a novice at all this but am keen to learn how it all works!

Many thanks in advance for any help you can give!

 

[plog]

What fields would the head offices have that the branches would not? If the answer is nothing, then you should put them all in one table with just a field to designate if they office is the head office.

 

[beanie_d83]

There aren't any fields that the head offices have that the branches don't so given that I guess it makes sense to put them all in one table.


What I ultimately want to achieve is when producing a from, I want to be able to select the dealer name from one drop down list and have it filter all the branches under that name in another drop down list. Presumably though, I will need to run a query/macro for it to do this?

 

[plog]

What you want is a cascading combo box. Search this forum or google for that term.

 

[beanie_d83]

Ok I shall keep that in mind and give it a go later. Many thanks for your help