can we create relastionship bet 2 tables in ms-access
Answers were Sorted based on User's Feedback
Answer / prem
yes.
1.go "tools"
2. select "relationship"
and add table n which u want to make relationship.
now drag.
| Is This Answer Correct ? | 24 Yes | 1 No |
State some of the uses of MS Access?
What is the purpose of ms access?
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
What is microsoft access write its features?
How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.
What is a super key? How is it different from a candidate key?
What is record in ms access?
How do you create a database in access?
What are the advantages of microsoft access?
Explain how you can build a relationship between the different databases in access?
How do I create an access database from multiple excel files?
Does office 365 include microsoft access?
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)