j000You want to create a form that shows all the dealers in each salesperson's region. This is called a one to many relationship because each salesperson serves many dealers in that region.
j010You already have a Salesrep database and a Dealers database. You can join the two to display just the data you need.
j020First youÆll select Open from the file menu, click on REPS.APR and click OK. Click the Design icon to go to Design.
j030Select Join from the Create menu to join the two databases.
j040To select the second database, click on Open.
j050Select DEALERS.DBF and click OK.
j060Now you need to select a field that the two databases have in common, in order to join them. Click on REGION in both databases and click Join.
j070You can now work with any field in both databases to create your form. Click OK.
j080You are ready to create your Territories form. Select Form from the Create menu.
j090You'll name this form Territories and choose Standard with a Repeating Panel from the SmartMasters Layout list.
j100Click Next to go to Step 2: choosing the fields for your form.
j110From the REPS database you want to include the SALESREP field and the REGION field.
j120Now click Next to set up the repeating panel.
j130Here is where all of the dealers for each sales rep and region will appear. Notice that you are now working with fields from the DEALERS database.
j140Click on the COMPANY field and click Add. We'll add the ADDRESS fields for you.
