JohnDing 0 Posted January 29 Share Posted January 29 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
comment 1,799 Posted January 29 Share Posted January 29 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
JohnDing 0 Posted January 29 Author Share Posted January 29 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
comment 1,799 Posted January 29 Share Posted January 29 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
JohnDing 0 Posted January 29 Author Share Posted January 29 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
JohnDing 0 Posted February 1 Author Share Posted February 1 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? Link to post Share on other sites
comment 1,799 Posted February 1 Share Posted February 1 If you don't mind the interface (e.g. two scrolls), sure, why not. Link to post Share on other sites
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now