I want to display two table data in one list.

[bonsai]

Below are the requirements.
Are there any out-of-the-box features that meet these requirements?
I thought I could use a database view,
but is there a limit to the amount of information that can be displayed?

- There are two custom tables.
- The two tables each have a different form layout.
- The user has requester privileges.
- Records are added to the two custom tables daily.
- Records from both tables are displayed in a single list.
- Users operate through the portal screen.

[Dr Atul G- LNG]

Hi @bonsai 

You can create a database view, but it does not provide a form interface. A database view can be used for reporting purposes, not for form views.

[bonsai]

Would it be possible to meet the requirements by creating a parent table for the two custom tables and providing two custom tables that extend the parent table?

Since the records of the two tables are stored in the parent table,
I believe they can be displayed in a single list.

[Dr Atul G- LNG]

Hi @bonsai 

yes but that will be customisation and by BR /scripts you can do 

[Rohit Ladda]

Yes, this can be done. But again depends on what you want to achieve, just show as list or provide any actions from the list as well.