Camee
Member
Hello,
I made several lists like
"Country", "ZIP", "City" to use in my "Customers" list and
"Routes", "Drivers" and "Vehicles" to use in my "Tours" list. "Routes" and "Drivers" use also "Country", "ZIP" and "City" lists.
Which is the best way to bring "Customers" and "Tours" together, for example to create an order or invoice? I don't like to enter customers data twice. I'd like to chose a customer name and a tour name and all required data (Adress, VATNumber, etc.) will be filled in automatically out of the two seperate lists. Is this possible?
I think there are too many joins and with all the joined data and double elements it's getting really confusing. I see only trees, many trees
I need a really good plan.
Kind regards
I made several lists like
"Country", "ZIP", "City" to use in my "Customers" list and
"Routes", "Drivers" and "Vehicles" to use in my "Tours" list. "Routes" and "Drivers" use also "Country", "ZIP" and "City" lists.
Which is the best way to bring "Customers" and "Tours" together, for example to create an order or invoice? I don't like to enter customers data twice. I'd like to chose a customer name and a tour name and all required data (Adress, VATNumber, etc.) will be filled in automatically out of the two seperate lists. Is this possible?
I think there are too many joins and with all the joined data and double elements it's getting really confusing. I see only trees, many trees
I need a really good plan.Kind regards