screwed up By using MultiValue-How can i undo this ?

[fuecheefang]

screwed up By using MultiValue-How can i undo this ?

[June7]

First, create the dependent table for the 'multiple' records represented by the multi-value field.

Second, build a query that expands the multiple values to separate records. https://support.office.com/en-us/art...E9BEBBEC31#bm7

Third, use that query as source to populate the table.

Fourth, delete the multi-value field.

Fifth, fix Relationships if set.

Sixth, fix forms and reports.

[fuecheefang]

First, create the dependent table for the 'multiple' records represented by the multi-value field.

Second, build a query that expands the multiple values to separate records. https://support.office.com/en-us/art...E9BEBBEC31#bm7

Third, use that query as source to populate the table.

Fourth, delete the multi-value field.

Fifth, fix Relationships if set.

Sixth, fix forms and reports.

Ive got the Multivalue Field to expand with a query now but as I use the make new table query to create the dependent table you mentioned, the Values of the multivalue come as thru as Number Values instead of the names.

From Query From Make a Table

[June7]

That's because the actual values in the field are the ID from Owners. The ID is the PK/FK link. This is appropriate.

The OwnerID should be the PK/FK link, should not save full name. Names make very poor links.

Now that you have a normalized table, retrieve the owner names in query that joins tables.