Hi,
I have a list (of conferences) with associated information (staff - multiple - attending) in MS Project and I'm pulling this into Access to store.
I have created a permanent table in Access which includes a Multiple Value Listbox to store the staff information.
I am using a temporary table to bring in all the information from MS project and store it until needed in the 'permanent' database table.
I am using SQL CREATE TABLE to, well, create the table, but I can't find a away to programmatically create a multiple value field.
I know that a more rigorous method would be to create a linked table to store the staff attending information, but I prefer (in this instance) the display of the information on / in a single line (in the listbox).
Any help greatly appreciated.
Many thanks,
Simon
I have a list (of conferences) with associated information (staff - multiple - attending) in MS Project and I'm pulling this into Access to store.
I have created a permanent table in Access which includes a Multiple Value Listbox to store the staff information.
I am using a temporary table to bring in all the information from MS project and store it until needed in the 'permanent' database table.
I am using SQL CREATE TABLE to, well, create the table, but I can't find a away to programmatically create a multiple value field.
I know that a more rigorous method would be to create a linked table to store the staff attending information, but I prefer (in this instance) the display of the information on / in a single line (in the listbox).
Any help greatly appreciated.
Many thanks,
Simon