Jump to content

How to show data from 2 tables with list layout


Recommended Posts

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.

Link to post
Share on other sites

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. 

 

Link to post
Share on other sites

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

Link to post
Share on other sites
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?

 

Link to post
Share on other sites

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. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.