Solved

Master-Detail with dbase tables

Posted on 1997-08-05
1
306 Views
Last Modified: 2013-11-24
I have two dbase tables. One is the master table with two fields as index (i.e. client;work) and the other is the detail table with also the previous two fields as index. Th problem is that I can't find a way to connect this tables as  master-detail via this two key fields. I did this before but just with one field as index and it worked, but when I try to do it with the Field Link Designer I only can connect one field. If I set the MasterFields property to 'CLIENT;WORK' and then I firs open the master table and then the detail I get a 'Field index out of range' error. Please, I need help!

Thanks in advance
0
Comment
Question by:sime
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
icampbe1 earned 100 total points
ID: 1340571
Although the documentation 'suggests' that you can, you really can't use two separate index fields like that.  You can however, create a dbase expression index using the combined fields (as long as they are character or string type).. this works but I'm not sure it will achieve exactly what you want.  
Another way to go, is to use one of the index fields for the master/slave relationship, and then use the 'OnFilterRecord' event to qualify the records on the other index.  This works as well.
Finally, you could use a Paradox table.

Cheers,
Ian C.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question