MS Access - Multiple options record in 1 field.

  SheffieldSpy 08:40 24 Sep 2003
Locked

I am trying to build a sales database. In it I also want to schedule delivery days. I want the database to record for each customer the days that delivery cannot be made. I have a multi selection list box, but even though the control source is the field I want, it doesn't record a value.

  madPentium 10:47 24 Sep 2003

I think a list box is just for bringing up record data that already exists.
The simplest way would be to create a seperate table for the days and link it (relationship) to the main table using a unique field such as the order number.
You can have the two tables showing on the same form too.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Inside the iMac Pro - Apple's most powerful Mac yet

iMac Pro release date, UK price & specs

Comment nettoyer Windows et optimiser son PC gratuitement ?