Wondering is this is possible - I have 2 tables. One is categories,
and has catid, catname, hashighercat, and ...I can't think of the 4th
one, but it isn't needed anyway.
There are 40 categories, and about 1400 subcats. the categories are
numbered 1-40, and the rest have their numbers - all of these are in
the same field - catid. You can tell the categories from the
subcategories by the field hashighercat - the 40 categories are null
here, and the subcategories have the categoryid that they belong to.
the product table contains fields for category, catid, subcategory,
and subcatid.
currently, I have a list value lookup for the category field, so the
values can be filled in by typing 1 or 2 or 3 letters. This isn't
connected to the category table.
What I need is - when I type in the category, the catid number should
automatically fill in into the next field (catid). then in the next
field (subcategory) there would now be a dropdown box with the
subcategories for that category only.
Then, when I pick one of the subcats, it's subcatID number would
automatically fill in the last field (subcatid).
Is this possible? By queries? Or by VBA? or how?
Thanks 3 1414
I'm confused. Are you? You say you have 2 tables then apparently refer to a
table of categories, a table of sub categories and a table of products.
I am guessing that you have something like
Product Sub category Category
Edam Cheese Dairy Products Food
5 mm Drill Drill bits Tools
You want a form that you select Tools. Then you get a dropdown to select
Hammers, Drill Bits Saws etc
Then having selected Drill bits you want a second dropdown showing 1mm
Drill, 2mm Drill, 5mm Masonry drill etc.
If so it is nearly all queries and a bit of code.
Please clarify your requirements and I'm sure you will get some help
Phil
<ji*******@gmai l.comwrote in message
news:a5******** *************** ***********@k30 g2000hse.google groups.com...
Wondering is this is possible - I have 2 tables. One is categories,
and has catid, catname, hashighercat, and ...I can't think of the 4th
one, but it isn't needed anyway.
There are 40 categories, and about 1400 subcats. the categories are
numbered 1-40, and the rest have their numbers - all of these are in
the same field - catid. You can tell the categories from the
subcategories by the field hashighercat - the 40 categories are null
here, and the subcategories have the categoryid that they belong to.
the product table contains fields for category, catid, subcategory,
and subcatid.
currently, I have a list value lookup for the category field, so the
values can be filled in by typing 1 or 2 or 3 letters. This isn't
connected to the category table.
What I need is - when I type in the category, the catid number should
automatically fill in into the next field (catid). then in the next
field (subcategory) there would now be a dropdown box with the
subcategories for that category only.
Then, when I pick one of the subcats, it's subcatID number would
automatically fill in the last field (subcatid).
Is this possible? By queries? Or by VBA? or how?
Thanks
Yes I am confused too!
In the products table, there are these fields
Category Catid Subcat Subcatid
Food 2 Meat 322
Drink 3 Soda 114
In the category table, we have
CatID CatName HigherCat HasSubCat
2 Food 0 Yes
3 Drink 0 Yes
114 Soda 1 [null]
118 Meat 2 [null]
322 Veggies 2 [null]
344 Beer 1 [null]
In the product table, I want to type "food" into [category], and have
"3" fill into [catid] automatically. Then [subcat] will have a dropbox
showing "meat" and "veggies". I choose one of them, say "veggies", and
"322" will fill into [subcatid] automatically.
I hope that makes better sense!
=============== =============== =============
On Jul 23, 5:59*pm, "Phil Stanton" <p...@myfamilyn ame.co.ukwrote:
I'm confused. Are you? You say you have 2 tables then apparently refer toa
table of categories, a table of sub categories and a table of products.
I am guessing that you have something like
Product * * * * * * * *Sub category * * * * * *Category
Edam Cheese * * * *Dairy Products * * * *Food
5 mm Drill * * * * * *Drill bits * * * * * * * * * *Tools
You want a form that you select Tools. Then you get a dropdown to select
Hammers, Drill Bits Saws etc
Then having selected Drill bits you want a second dropdown showing 1mm
Drill, 2mm Drill, 5mm Masonry drill etc.
If so it is nearly all queries and a bit of code.
Please clarify your requirements and I'm sure you will get some help
Phil
<jillin...@gmai l.comwrote in message
news:a5******** *************** ***********@k30 g2000hse.google groups.com...
Wondering is this is possible - I have 2 tables. One is categories,
and has catid, catname, hashighercat, and ...I can't think of the 4th
one, but it isn't needed anyway.
There are 40 categories, and about 1400 subcats. the categories are
numbered 1-40, and the rest have their numbers - all of these are in
the same field - catid. You can tell the categories from the
subcategories by the field hashighercat - the 40 categories are null
here, and the subcategories have the categoryid that they belong to.
the product table contains fields for category, catid, subcategory,
and subcatid.
currently, I have a list value lookup for the category field, so the
values can be filled in by typing 1 or 2 or 3 letters. This isn't
connected to the category table.
What I need is - when I type in the category, the catid number should
automatically fill in into the next field (catid). then in the next
field (subcategory) there would now be a dropdown box with the
subcategories for that category only.
Then, when I pick one of the subcats, it's subcatID number would
automatically fill in the last field (subcatid).
Is this possible? By queries? Or by VBA? or how?
Thanks- Hide quoted text -
- Show quoted text -
That's wrong - should be
Category Catid Subcat Subcatid
Food 2 Meat 322
Drink 3 Soda 114
In the category table, we have
CatID CatName HigherCat HasSubCat
2 Food 0 Yes
3 Drink 0 Yes
114 Soda 3 [null]
118 Meat 2 [null]
322 Veggies 2 [null]
344 Beer 3 [null] This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: cooldv |
last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195
will someone help me understand:
1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
|
by: Puvendran |
last post by:
Hi,
We have encountered deadlock on a table which is used to generate
sequential numbers for different categories eg typical entries
Category Value
TRADE_NO 1456
JOB_NO 267
.....
|
by: Fred |
last post by:
Hi.
How do I import while mapping an excel table to an access table please???
I've searched around and all I can find is a software product or code that
does the same thing as the access wizard.....
If I have to write vb code, where is a sample???
Or do I import the excel in to a new spreadsheet and then
write some kind of querey to move the data from that table
|
by: Innuendo |
last post by:
Hello,
I'm not a specialist with Access - so I hope that you can give me some
input.
I've to import xml data (about 15 different data fields) into an
access-database each night. As scripting language I've to use ASP.
Do you think there will be a problem with about 20.0000 to 30.000
data-records, which have to be updated (about 99 % of the data-records
|
by: Decreenisi |
last post by:
Hi,
I have to convert an existing spreadsheet for rejects into an access
database. My problem is I use a load of lookup tabels in excel. How do
I approch this in access. Also, just a general question, can you do
pivot tables in access.
Thanks
| |
by: Kevin G. Anderson |
last post by:
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG
Social
When: Thursday, May 25, 2006, 6PM
Who: Chris Monaghan and Kevin Anderson
Where: The Information Management Group
200 W. Monroe St. Suite 900
Chicago, IL 60606
(312) 222-9400
Location: www.imginc.com/IMG/About+IMG/chicago.htm
|
by: Michael M. |
last post by:
Hi all,
I would like to know how to access the NT/2000/XP/2003 Name cache; what I
mean by this is:
Open a Command Prompt and..,
C:\>
C:\>IPCONFIG /DISPLAYDNS
|
by: sparks |
last post by:
First question is there a way to tell who is logged into a database on
a server?
I did some checking and found several things at MS support for access
2007, log in run some code and get a list.
The problem is all of these databases are access 97 and 2003
The databases are not set for exclusive access, the problem comes when
we have to make a change and someone left it on their desktop and
forgot to log out.
|
by: O |
last post by:
I need to do some lookups and updates on some legacy Access 2.0 files
(they've from another vendor and I'm not in a position to update them).
I was successful using VB6, but I've moved on to VS 2005 and ADO and
having some serious problems.
Here's the scenario:
2 people have the same Access 2.0 databases running in the Access 2.0
application.
|
by: netnewbie78 |
last post by:
Hello All,
I don't have a problem (but maybe I will after I explain). I have a
question with regards to something I saw in Access 2007. But first, a
little backstory:
I'm writing a very small stock database. For now, it will simply track
what products come in (Stocks bought by Project) and what products go
out (Stocks sold to by Project) . There are three tables: Products,
Transactions and Projects.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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.
| |