How to show data from 2 tables with list layout

[JohnDing 0]

I have two order tables. A bikeOrder table and a carOrder table.  I now wants to have a list view where i can view all orders in the system, with a list layout but cant figure out how.

any feedback is appreciated.

[comment 1,799]

If you want to see all orders in a list view, you must put them in the same table. If you like, you can keep them in 3 tables - bike orders, car orders and a combined list - but I doubt such complexity is necessary. 

 

[JohnDing 0]

How would i make a combined list? When a order is created the data is inserted into car order table and the combined table?

[comment 1,799]

17 minutes ago, JohnDing said:

How would i make a combined list?

You have two options: 

1. Import the orders you want to show into a third table;

2. Create the orders by entering data into both the combined table  and one of the specific tables, with a one-to-one relationship between them.

Again, I don't think any of this is necessary - esp. if you rate yourself as beginner. What is the reason you need to keep the orders in separate tables? Why isn't it sufficient to have a field for the type of order?

 

[JohnDing 0]

Its an older system (around 10 years) and was build around one product only (cars) and i have been given the task (with no experience in FM) to expand the system for a new product (bikes). So right now the order table has a lot cars specific fields and calculations.  I then decided to make a bike order table for bike orders only since the process for handling the orders is two different processes. 

[JohnDing 0]

if i cant use a list view, would a layout with 2 portals do it? A portal for bike order and one for car orders?

[comment 1,799]

If you don't mind the interface (e.g. two scrolls), sure, why not.