From 1:N to a foreign key
We will implement one shopper to many orders, with one required shopper per order. Distinguish three questions: where is the number stored, may it be NULL, and must it reference an existing row?
Each order form carries its shopper number. One shopper can appear on many forms. Filling every form does not guarantee that every shopper already has a form.