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
- 2336 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you use microsoft access database?
What is microsoft access write its features?
what do u mean by heptic shedule over india
What is the function of ms access?
What are the disadvantages of microsoft access?
Difference between MS Access and Oracle
Does office 2019 include microsoft access?
What is the size limitation of an Access database?
What are the basic features of ms access?
Explain superior keys and candidate keys. How are they different?
How do you check if ms access is installed?
What is microsoft access database?
-
Oracle (3259) - 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)
