Adding .Value field problem

  • Thread starter Thread starter Maul
  • Start date Start date
M

Maul

While making a database I added an existing field from the field list and it
inserted the field but every value shows up on a separate line and I would
like to have it on a single line, is there any simple way to fix this problem?
 
While making a database I added an existing field from the field list and it
inserted the field but every value shows up on a separate line and I would
like to have it on a single line, is there any simple way to fix this problem?
Click to expand...

Um....

That's not a "problem". That's how databases work. Fields in a table should be
atomic, having only one value.

What is the nature of your data? What is the structure (now) of your table?
What would you LIKE to see? Please post a sample.
 
John W. Vinson said:
Um....

That's not a "problem". That's how databases work. Fields in a table should be
atomic, having only one value.

What is the nature of your data? What is the structure (now) of your table?
What would you LIKE to see? Please post a sample.
Click to expand...

The field I am trying to insert was made as a multi value field that you
check marked which items would show for those companies. when i inserted the
field however they showed up on a separate line for each item making multiple
copies of the companies and their price quotes. i would like for the inserted
field to show all items on one line so that i don't wind up with duplications
of companies.
 
Back
Top