Interested to Buy Any Domain ? << Click Here >> for more details...
I have a reference table called 1. of 2 fields called
1.BadgeGroups(BG)and 1.Badges(B)like
BG G
aa 10
aa 11
bb 12
bb 13
bb 14
Using MS Design View
Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group
In Table 2 called 2. they calls Table 1 for 2 fields
BUT with the second field 2.badges, I want the combo box
only to display the 1.badges where 2.badgegroup =
1.badgegroup
The current select I have is for Table Data View Row Source
is:
2.badgegroup is filled from a Combo box using Select
Distinct etc from Table 1.
Tried different syntax's but still lost, looking for some
help
SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE
1.[BadgeGroup]=Me.2.BadgeGroup);
I can populate 2.badgegroup with a
- 0 Answers
- 2378 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How you can create a table using maol (microsoft access object library)?
What is the difference between integer and long integer in access?
What are the applications of ms access?
how to toggle ms word to ms excel or ms excel to ms word
What are the advantages of ms access over ms excel?
Does ms access use sql?
What are the basic features of ms access?
What are the important features of ms access?
How do I install microsoft access 2013?
What is the best alternative to microsoft access?
How many views are there in ms access?
How many rows can you have in an access table?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
