I want to make report in foxpro, with relationship. I have tables "Costumer" and "Order". Which "Order" table has foreign key "IDCostumer". But i want to show in the Order report the name of costumer instead of "IDCostumer". i hope you understand my question, sorry if my english very bad.
Asked
Active
Viewed 1,306 times
-1
-
So? What seems to be the problem? – PM 77-1 Jan 14 '15 at 02:21
-
the codes :) i don't know how to use set relation to....order data is shown but not the name of costumer – Joni Lelet Jan 14 '15 at 02:23
-
1http://msdn.microsoft.com/en-US/library/zkyz3407%28v=vs.80%29.aspx What exactly isn't clear? – PM 77-1 Jan 14 '15 at 02:24
-
I write the code: select order->set relation to IDCostumer into Costumer->report form "my/report" preview.....the order data seen but name of costumers not....the field in the report is Costumer.name....how to show the name instead of IDCostumer? – Joni Lelet Jan 14 '15 at 02:39
-
Do you have **both** tables opened? – PM 77-1 Jan 14 '15 at 02:43
-
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/68786/discussion-between-pm-77-1-and-joni-lelet). – PM 77-1 Jan 14 '15 at 02:46
-
Show some examples of what you have tried. – KindaTechy Feb 20 '17 at 17:32
1 Answers
-1
I got the problem. The problem is the length of data. I make mistake to make table. The length of IDCostumer field is different with the length of Foreign key IDCostumer in order table. that makes data not shown in the report. ok then bye
Joni Lelet
- 47
- 6
-
This isn't a helpful answer for this website. While you have discovered the answer to your own problem, it does not help anyone else because you haven't actually provided that answer. – KindaTechy Feb 20 '17 at 17:32