how to create a dependent drop down by referencing the colomn from the other table?
For example consider an app called school there are two tables BASIC INFORMATION & ACADEMICS in basic information columns be like NAME ROLL NO in ACADEMICS
columns be like CLASS SUBJECTS and i want dependent drop down for
NAME, ROLL NO, CLASS, SUBJECTS
There can be a few different approaches but based on your information given, you can use references for pulling Na me and Roll Number information from BASIC INFORMATION into ACADEMICS table. References because there is unique combination of Name and Roll Number for each student. You may wish to go through article listed at the bottom of this post for how to create references.
For pulling in name into ACADEMICS table, you can set Name column of ACADEMICS table as Column type “Ref” and Referenced table name as BASIC INFORMATION in that column’s definition.
For Roll number column, you can write expression such as [Name].[Roll Number] in Roll Number column of ACADEMICS table. Here [Name] is the name of the Name column in ACADEMICS table.
Your CLASS and SUBJECTS column, if they are not dependent on any other column, you can use simple Enum type columns for these columns.
You can also store this CLASS and SUBJECTS information in another third lookup table and write a formula like SELECT(LOOKUPTABLE[CLASS],TRUE) in CLASS column of ACADEMICS table and similarly SELECT(LOOKUPTABLE[SUBJECTS],TRUE) IN
SUBJECTS column of ACADEMICS table.
Any sample apps??
HI dependent drop down is not working after referencing!! and imagine every column is dependent on each other like roll no is dependent on name &class dependent on roll no and subjects dependent on class.
For drop downs , I shared a sample app in my first post in this thread.
For table references , you can please refer following app
Hi @Jagadeesh_G, You may wish to go through the following