MS Access - Multiple options record in 1 field.

  SheffieldSpy 08:40 24 Sep 2003

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

Samsung Galaxy S9 review

ManvsMachine and other artists put Apple's iMac Pro to the test using powerful rendering tools

What to expect at Apple's 27 March education event

Comment filmer l’écran d’un iPhone ?