Hello,
I have database, which contains the list of laptop companies and some
information about them.
Some laptop models, have series, sub series, family's and so on.
for example. Acer Aspire 5102WLMi.
Company: Acer
Family: Aspire
Serie: 5100
Model: 5102WLMi
another example would be
IBM Lenovo ThinkPad A22m 2628 AG1
Company: IBM Lenovo
Family: ThinkPad
Serie: A22m
Type: 2628
Model: AG1
Most of them have up to 4 main categories, such as Company, Family,
Serie and Model, but some of them like IBM Lenovo have more
categories.
At that moment I made 1 special table for IBM (type) and this one is
in the middle of the serie and model. Now I need to write some extra
code for every operation I make with data such as if company == IBM
then bla bla and so on.
I realy believe that there is solution how to automate this whole
thing even if there would be more sub categories in the future with
other models.
Any Ideas ?
Sincerely,
Dmitrij
3  2199 
I have a table listing only auto makes
(like Acura, AMC, Audi, BMW...) And
then I have another table with some-
thing like the table that follows. Whereas
I only have Make / Model ==you have
Company, Family, Serie and Model. It is
possible that you could have a set of
related tables: The first would list only
COMPANYs. The second would list
COMPANYs and FAMILYs. The third
would list FAMILYs and SERIES. The
next would list SERIES and MODELs.
I'm sure you would have to come up
with your own naming convention to
handle situations in which 2 different
COMPANYs might use the same FAMILY
name or SERIES name or MODEL name.
With a little work, though, you could make
it happen. Hopefully helpful.
Make Model
Acura CL
Acura CSX
Acura EL
Acura Integra
Acura Legend
Acura MDX
Acura NSX
Acura RDX
Acura RL
Acura RSX
Acura SLX
Acura TSX
Acura TL
Acura Vigor
AMC Ambassador
AMC American
AMC AMX
AMC Classic
AMC Concord
AMC Eagle
AMC Gremlin
AMC Hornet
AMC Javelin
AMC Marlin
AMC Matador
AMC Pacer
AMC Rambler
AMC Rebel
AMC Spirit
AMC Other
Audi 100
Audi 200
Audi 4000 Coupe GT
Audi 4000 Coupe Quattro
Audi 4000 Quattro
Audi 4000 Sport Coupe
Audi 4000 2 & 4 Door Sedan
Audi 5000 & 5000 Quattro
Audi A3
Audi A4
Audi A6
Audi A8
Audi AllRoad
Audi Cabriolet
Audi Fox
Audi Q7
Audi RS4
Audi RS6
Audi S4
Audi S6
Audi S8
Audi 80 Series
Audi 90 Series
Audi Super 90
Audi TT
Audi V8 Quattro
BMW 1602
BMW 1800
BMW 2002
BMW 2500
BMW 2800
BMW 3.0
BMW 318i
BMW 320i
BMW 323I
BMW 325e
BMW 325i
BMW 328i
BMW 330i
BMW 335i
BMW 524TD
BMW 525i
BMW 528e
BMW 528i
BMW 530i
BMW 533i
BMW 535i
BMW 540i
BMW 545i
BMW 550i
BMW 630CSi
BMW 633CSi
BMW 635CSi
BMW 645Ci
BMW 650i
BMW 728
BMW 732
BMW 733i
BMW 735i
BMW 740i
BMW 745i
BMW 750i
BMW 760i
BMW 840i
BMW 850i
BMW L6
BMW L7
BMW M3
BMW M5
BMW M6
BMW Mini Cooper
BMW X3
BMW X5
BMW Z3
BMW Z4
BMW Z8
Buick Allure
Buick Apollo
Buick Century
Buick Enclave
Buick Electra (1980 Up)
Buick Electra (1979 Down)
Buick Lacrosse
Buick LeSabre (1980 Up)
Buick LeSabre (1979 Down)
Buick Limited
Buick Lucerne
Buick Park Ave (1980 Up)
Buick Park Ave (1979 Down)
Buick Rainier
Buick Reatta
Buick Regal (except Somerset)
Buick Regal Somerset (1985 Up)
Buick Regal Somerset (1982 Down)
Buick Rendezvous
Buick Riviera
Buick Roadmaster (1980 Up)
Buick Roadmaster (1979 Down)
Buick Skyhawk
Buick Skylark
Buick Special
Buick Terraza
Buick Other
Cadillac Allante
Cadillac Brougham
Cadillac CTS
Cadillac Catera
Cadillac Cimarron
Cadillac Concours (2000 Up)
Cadillac Concours (2000 Down)
Cadillac DeVille (1980 Up)
Cadillac DeVille (1979 Down)
Cadillac DTS
Cadillac Eldorado
Cadillac Escalade
Cadillac Escalade-EXT
Cadillac Escalade-ESV
Cadillac Fleetwood (1980 Up)
Cadillac Fleetwood (1979 Down)
Cadillac Seville (incl STS)
Cadillac SRX
Cadillac STS
Cadillac XLR
Cadillac Other
Chrysler 300M
Chrysler 300
Chrysler Aspen
I think one table would do nicely .
ie. If the category doesn't apply to some of the items then leave
blank.
Then make your queries.
Sounds like an excel job though yours is.
rgds
Thanks for your reply, however I do not think that this idea would
help me or I can not imagine how to use it as I have one more table,
which contains groups of models. I mean, for example acer 1600 series
and dell c600 could be in the same group. I coudln't find out the way
how to do it with your way.
Anyway your solution is interesting for me.
Now I am trying to put information into that extra table even if the
model doesn't have it (just put -1 if it doesn't).
Thanks one more time.
On Nov 5, 12:36 am, MLH <C...@NorthStat e.netwrote:
I have a table listing only auto makes
(like Acura, AMC, Audi, BMW...) And
then I have another table with some-
thing like the table that follows. Whereas
I only have Make / Model ==you have
Company, Family, Serie and Model. It is
possible that you could have a set of
related tables: The first would list only
COMPANYs. The second would list
COMPANYs and FAMILYs. The third
would list FAMILYs and SERIES. The
next would list SERIES and MODELs.
I'm sure you would have to come up
with your own naming convention to
handle situations in which 2 different
COMPANYs might use the same FAMILY
name or SERIES name or MODEL name.
With a little work, though, you could make
it happen. Hopefully helpful.
Make Model
Acura CL
Acura CSX
Acura EL
Acura Integra
Acura Legend
Acura MDX
Acura NSX
Acura RDX
Acura RL
Acura RSX
Acura SLX
Acura TSX
Acura TL
Acura Vigor
AMC Ambassador
AMC American
AMC AMX
AMC Classic
AMC Concord
AMC Eagle
AMC Gremlin
AMC Hornet
AMC Javelin
AMC Marlin
AMC Matador
AMC Pacer
AMC Rambler
AMC Rebel
AMC Spirit
AMC Other
Audi 100
Audi 200
Audi 4000 Coupe GT
Audi 4000 Coupe Quattro
Audi 4000 Quattro
Audi 4000 Sport Coupe
Audi 4000 2 & 4 Door Sedan
Audi 5000 & 5000 Quattro
Audi A3
Audi A4
Audi A6
Audi A8
Audi AllRoad
Audi Cabriolet
Audi Fox
Audi Q7
Audi RS4
Audi RS6
Audi S4
Audi S6
Audi S8
Audi 80 Series
Audi 90 Series
Audi Super 90
Audi TT
Audi V8 Quattro
BMW 1602
BMW 1800
BMW 2002
BMW 2500
BMW 2800
BMW 3.0
BMW 318i
BMW 320i
BMW 323I
BMW 325e
BMW 325i
BMW 328i
BMW 330i
BMW 335i
BMW 524TD
BMW 525i
BMW 528e
BMW 528i
BMW 530i
BMW 533i
BMW 535i
BMW 540i
BMW 545i
BMW 550i
BMW 630CSi
BMW 633CSi
BMW 635CSi
BMW 645Ci
BMW 650i
BMW 728
BMW 732
BMW 733i
BMW 735i
BMW 740i
BMW 745i
BMW 750i
BMW 760i
BMW 840i
BMW 850i
BMW L6
BMW L7
BMW M3
BMW M5
BMW M6
BMW Mini Cooper
BMW X3
BMW X5
BMW Z3
BMW Z4
BMW Z8
Buick Allure
Buick Apollo
Buick Century
Buick Enclave
Buick Electra (1980 Up)
Buick Electra (1979 Down)
Buick Lacrosse
Buick LeSabre (1980 Up)
Buick LeSabre (1979 Down)
Buick Limited
Buick Lucerne
Buick Park Ave (1980 Up)
Buick Park Ave (1979 Down)
Buick Rainier
Buick Reatta
Buick Regal (except Somerset)
Buick Regal Somerset (1985 Up)
Buick Regal Somerset (1982 Down)
Buick Rendezvous
Buick Riviera
Buick Roadmaster (1980 Up)
Buick Roadmaster (1979 Down)
Buick Skyhawk
Buick Skylark
Buick Special
Buick Terraza
Buick Other
Cadillac Allante
Cadillac Brougham
Cadillac CTS
Cadillac Catera
Cadillac Cimarron
Cadillac Concours (2000 Up)
Cadillac Concours (2000 Down)
Cadillac DeVille (1980 Up)
Cadillac DeVille (1979 Down)
Cadillac DTS
Cadillac Eldorado
Cadillac Escalade
Cadillac Escalade-EXT
Cadillac Escalade-ESV
Cadillac Fleetwood (1980 Up)
Cadillac Fleetwood (1979 Down)
Cadillac Seville (incl STS)
Cadillac SRX
Cadillac STS
Cadillac XLR
Cadillac Other
Chrysler 300M
Chrysler 300
Chrysler Aspen
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Dennis Gearon |
last post by:
IPU, in place updates.
--------------------------
1/ Put a version numbers on each record represented by a byte/word sized
number from a three version number list kept by the table header. This
would then only involve one more byte per record. This version number
list needs to be the VERY first item in the table header. The lowest
ordered...
|
by: Tom |
last post by:
I am looking for some ideas for how to design the layout of the form for
data entry and to display the data for the following situation:
There are many sales associates. A sales associate can work for multiple
companies and work for multiple divisions within each company. Within each
division he can work in multiple departments and within each...
|
by: HSP |
last post by:
hi.
i need to restore an old database. The db was backed up using a DLT drive,
using 2 volumes. The content for the tapes was copied to file onto Solaris
machine using rsh and dd (for backup purposes). Now, the drive is defective
and can't read the tapes anymore.
Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version...
|
by: Miguel Dias Moura |
last post by:
Hello,
I am working on an Asp.Net 2.0 / SQL 2005 web site.
I am using profile to save the users info on the database.
For example, I have the following structure:
Public Structure Name
Public First As String
Public Last As String
End Structure
|
by: clinttoris |
last post by:
Hello,
If someone could help me it would be appreciated as I am not having
much luck.
I'm struggling with my asp code and have some questions relating to asp
and oracle database.
First question. I have a web survey that I am working on and have
successfully dynamically taken the info from a database, displayed it
on the screen and then...
| | |
by: Anders B |
last post by:
I want to make a program that reads the content of a LUA array save file..
More precicely a save file from a World of Warcraft plugin called
CharacterProfiler, which dumps alot of information about your characters
into that save file.
Anyhow, I want to extract a couple of lines of it and save it into a
database and I need help on figuring...
|
by: Charles May |
last post by:
Anyone have a simple concept for the best way to store timeclock information
in a database.
I currently have my table set up like this with a typical daily entry.
tcID empID Type Date Time
1 37 'Clockin' 1/18/08 7:45:39 AM
2 38 'Clockin' 1/18/08 7:55:42 AM
3 ...
|
by: Eric Wertman |
last post by:
I have a set of files with this kind of content (it's dumped from WebSphere):
]
|
by: jehugaleahsa |
last post by:
Hello:
I have a bunch of related items that are either parents, children or
not directly related to each other. In my case, I have a bunch of
database tables joined with foreign keys. Another example would be a
family tree.
I would like to take a flat list of these items and build the
hierarchy. So, in other words, I would like to take...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
