General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Having Grid & View Trouble
Hi everyone,
I am new to the VFP Environment and have been trying to convert some old DOS base apps
over to the VPF platform. But I still have not been able to understand or get it to work properly.
Let me try to explain, my tables are as follows:
..........[ANITABLE]...[CUSTOMER]....[ANITBL]...[TFREETBL]...[CCT]
Key......tktnum...............cid...............aninum......tfreenum........ccn
FKey.....cid....................cid..................cid............cid
FLd1....Cname..............cname...............................................chname
As you can tell the [ANITBL] AND [TFREETBL] only have the phone number (aninum)
and the tollfree number (tfreenum) respectively. That is the only data that I need from
them. The [CCT] has another field (chname) but I do not need it in the [ANITABLE]
form. I have tried to create 3-4 single views then create one view from the single views
to give me the fields that I need for the grid, but it did not work. I tried to create a single view
with those same tables and still could not get it to come up with the right data. My best effort
was when I came up with the data but it was duped. In another words, see the following..
Cust #132 has (2) phone #'s and (1) 800 and (1) calling card like this
.................[aninum]........[tfreenum]....................[ccn]
phone#: 3181231234..800#:8001231234....CC#:5570600
..............3181231235
Table View of all 3 table joined.
CID.....ANINUM.....TFREENUM....CNN
132...3181231234..8001231234..5570600
132...3181231235..8001231234..5570600
Now as you see there is only 1 customer but 2 cust #'s prob due to the fact that
there are 2 different ANI #'s but see the TFREE #'s dbl as well as the CNN #'s
Now I think that this is due to the 2 ANI's but I do not understand how to
get just the data I need. My screen with my grid [ANITABLE] should look
like the following:
________________________________________________________________
|.TKT#:132..................................................................DATE:02/25/2000....|
| .............................................................................................................|
| Michael Daniel............................Site#:1...........Monroe............................|
|..............................................................................................................|
|...........|ANINUMBER.......|..........Toll FREE........|.........CCN..............|.......|
|...........|318-123-1234.......|.......800-123-1234......|......557-0600..........|.......|
|...........|318-123-1235.......|.................................|.............................|.......|
|...........|..........................|..................................|.............................|.......|
|...........|_______________|___________________|_________________|.......|
|_______________________________________________________________|
Now please understand that ANINUMBER, Toll Free and CCN are the only Grid fields.
If you can help me solve or understand this problem, I would sure appceiate the help.
I love the environment and I am sure that VFP can do this but being as new to it as I am
It seems very alien to me.
Thank you for your time.
Mike Daniel
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only