You should consider having a "Car" table related to the Person Table in a one-to-many relationship.
Person Table ---< Car Table
Instead of having the fields Car1, Car2 and Car3.
Then use a summary report sorted by Car.
(Search this forum for PhilModJunk's tutorial on creating Subsummary reports)
Thanks for you both. As you informed me, I create a new table called cars. I created a relationship between my table users and the new one. I created a relation with id_user.
So, from my user table, I would like to create a field containing the information from the cars table. If a user have 3 cars, i would like to have a field which looks like honda, mazda,chrysler.
Do you have a hint to do that ? I prefer not using the related records portal if it's possible.
You can define a calculation field that looks like this:
Substitute( list(CarTable::CarName); "¶" ; ", " )
Though you won't be able to edit this list like you would in a portal.
Thank you so much. You are so brilliant. I don't know how you do it but it works very well.
One latest question. Is it possible to order this field ?
Your question intrigued me. I learned the above trick from a post by Comment and hadn't tried to get the list into a sorted order before. The answer, after doing a short test, is yes.
In the relationship that links your two table occurrences, specify a sort order and the results of the previously posted calculation should list the items in the order you specify in your relationship.
To select a sort order for this relationship:
- Bring up the relationship graph in Manage | Database
- Double click the line linking your two table occurrence boxes.
- On the "Car" side of this relationship, select the sort records option and specify a sort order.