
Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Hi,
This helps some, but I still cannot figure out how to make a
many-to-many link.
I thought about doing it like this:
tbl_Type:
ID
Type
tbl_Brand:
ID
Brand
Type
tbl_Line
ID
Line
Brand
Type
tbl_Model
ID
Model
Line
but how can I put multiple entries for (for example) brands?
Should it be like this:
ID Brand Type
1 Dell Laptop
2 Dell Computer
3 Dell Printer
4 Dell Monitor
and then put the SQL query to DISTINCT so it only shows Dell once?
regards,
Jeroen
Douglas J. Steele schreef:
> See whether http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx
> is enough to get you going.
[quoted text clipped - 73 lines]
> >
> > Jeroen
Douglas J. Steele - 31 Jul 2006 15:46 GMT
Strikes me that tbl_Brand should only contain ID and Brand, so that Dell and
IBM each only appear once in that table.
You'd then have a tbl_BrandType that contains what your current tbl_Brand
contains.
tbl_Line would then have:
ID Brand Type Line
1 Dell Laptop Inspiron
2 Dell Laptop Latitude
3 Dell Computer Optiplex
4 Dell Computer Precision
and tbl_Model would have
ID Brand Type Line
Model
1 Dell Laptop Inspiron
1300
2 Dell Laptop Inspiron
6400
3 Dell Laptop Latitude
D610
4 Dell Laptop Latitude
D620
Of course, you wouldn't actually have Brand nor Type as text fields in
tbl_Line: you'd store the Id from tbl_Brand and tbl_Type:
ID Brand Type Line
1 1 1
Inspiron
2 1 1
Latitude
3 1 2
Optiplex
4 1 2
Precision
Similarly, Brand, Type and Line wouldn't be text fields in tbl_Model. In
fact, you don't even need to store Brand and Type in that table, since you
can derive those from the tbl_Line ID:
ID Line Model
1 1 1300
2 1 6400
3 2 D610
4 2 D620

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> Hi,
>
[quoted text clipped - 121 lines]
>> >
>> > Jeroen