I see in your sample database you have employee table with first_name and Last_name fields. When entering an order in the orders table you are pulling a full_name field showing both the first and last names. How is that happening? or am I looking at the wrong tables and you have a table with the column full_name in it? Do you somehow combing first_name and Last_name for a full_name order entry field?
I see in your sample database you have employee table with first_name and Last_name fields. When entering an order in the orders table you are pulling a full_name field showing both the first and last names. How is that happening? or am I looking at the wrong tables and you have a table with the column full_name in it? Do you somehow combing first_name and Last_name for a full_name order entry field?
Thanks.
Figured it out, looking at the wrong table.
Hi Jay,
Thank you for your inquire.
Glad to hear that you found a solution. If you have any more question do not hesitate to ask.