If anyone can help me with this I would really appreciate it. I’m new to programming and I am trying to convert a dbase database to VPF 5.0. This is a pawn shop database done in dbase. Here is part of a table that I want to do something with. The problem is that it is a waste of space by using 6 separate records to describe 1 pawn ticket. What I want to do is make another table with only 1 record per pawn ticket# and append each one of these into one description field for each record. There are other fields that I would also have to save that I didn’t show. If anyone could just point me in the right direction maybe list some commands that I might be able to use.
Thanks kelly
Pawn ticket# Sequence description
0013972 1 10K LDS JEWELRY
0013972 2 AMBER BANGLE BRACELET,
0013972 3 BANGLE BRACELETS,WED BAND,
0013972 4 B PENDENT,LEAF RING,DIAM CHIP
0013972 5 PROMISE RING,BROKEN NUGGET
0013972 6 RING, AMOR HEART RING,