Welcome to the forums wardy91. You did not say what database you were using. I'm assuming MySQL, if different the idea is the same, implementation maybe slightly different.
You do not want to put the same information in different tables. It just wastes space. We can retrieve the data we need with JOINs. You have three tables members which contains custumer name and id
products which contains product id, name and cost
basket which should contains order number, order date, order status, custumer id and product id.
Lets just get the customer name, the product he/she ordered, and the oder number and status.
select o.ord_num, o.ord_status, c.cust_name, p.prod_desc from orders_tbl as o
JOIN customer_tbl as c
on o.cust_id = c.cust_id
join products_tbl as p
on p.prod_id = o.prod_id
where o.ord_num = '16C17'
or if we have the customers name we substitute where c.cust_name = 'PUT NAME HERE'
I am assuming that you know how to insert data. Your ordering form should give you the customer's name and what he ordered so you need to know how to generate the order number, order date, and order status. If you do you got it made, if not ask here.
Evolution - The non-random survival of random variants.