Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting a Temporary Relationship
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Setting a Temporary Relationship
Miscellaneous
Thread ID:
00206015
Message ID:
00206015
Views:
59
I have 2 tables that I would like to set up a temporary relationship for. The customer table has a field called cus_acct and the student(child) table has a field called stu_acct. I would like to set the relation based on these fields.

I have struggled with this for awhile now without any luck. It seems as if the reason I am having problems is that the field names in the 2 files are not the same. Is this true?

I do have an index in the student file called stu_acct which is STR(stu_acct)+STR(stu_sub) I also have an index in the customer file called cus_acct which is simply cus_acct. These fields (cus_acct, stu_acct and stu_sub) are Numbers and not Characters.

Can I set a relation like I am proposing?

Thanks,
Paul
Next
Reply
Map
View

Click here to load this message in the networking platform