I develope a database with FM 13. The Data of one part of the DB should be treated in this way,
There are about 20 lists and each list is assigned to different orders of one costumer. For example a Customer "John" has 200 orders and they should be numbered as John001, John002,...John199...
All of these orders have the same list. that means the above-mentioned 200 records have a identical list "Equiment".
That means finally I have 200 records, in which just the suffixs of "John" are different.
My question is, whether I should create really 200 records for each list or is there another way to have all these data without 200 times repeating
one record? Is there a better Idea?!
I thank you in Advance!