Hi @Jagadeesh_G,
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.
help.appsheet.com - References Between Tables References Between Tables help.appsheet.com
LinkedIn
Twitter
