/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $allcustomers = \App\Customers::orderBy('first_name')->get(); $customers = $allcustomers->lists('CustomerFullName', 'id'); $allproducts = \App\Products::orderBy('product_name')->get(); $products = $allproducts->lists('ProductShowInfo', 'id'); //\App\Products::lists('product_name','id'); return view('orders.create', compact('customers', 'products')); }