Hi guys
A newbie to Access, but read 200 pages of a great book and watched a number of YouTube videos so have lots of theory! In short, I want to make my data as streamlined as possible. I grasp how to split customers from orders and orders from order lines. What about customers who are shipping to multiple addresses? Is it better to have shipping address in as a field in Orders table despite the awfully repetitive and bulky nature of that approach? My preferred option is to do an Amazon: allow the user to store as many shipping addresses as they like against a customer (I guess a Shipping Address table, with address number (key field), account number and shipping address field, cross-referenced to customer and orders tables). What I then need (newbie question alert!) is a field in the Orders table called "shipping address number" or some such which could cross-reference with the relevant address in the Shipping Address table for that customer. Am I making sense? I guess I'm just looking for pointers for the best approach here re: structure, then I can roll my sleeves up and get on with learning the practical. I know this must be a commonly occurring phenomenon.
Thank you for reading my post, whether you can help with it or not, it is appreciated!
Pog