Help needed on the use of tables

[JOHNSON K G]

I am having a table with 3 columns. Just for representation purpose I have given names section, level and id.
If i want to make another table with section and level known, how can I get the corresponding id from the first table? Please help.

[UnklDonald418]

Welcome to the Forum.
It isn't entirely clear what you are trying to accomplish because from that standpoint of relational database design what you have presented here doesn't make much sense.
TableA is acceptable, but TableB should not duplicate the data from TableA. TableB would contain other related data and should have its own automatically generated Primary Key. It could then have something like TblA_ID as an Integer field to store the Foreign key value from TableA so a relationship between the two tables can be established. Then using that relationship a query could be designed that would allow the user to see all the relevant fields from both tables.
Well designed database tables are not necessarily readable by the user, they only need to make sense to the relational database engine.
A good introductory tutorial for databases that can be downloaded from:
https://wiki.documentfoundation.org/ima ... torial.pdf

[JOHNSON K G]

Thank you for the reply.