Oscar Castillo Posted January 13, 2020 Share Posted January 13, 2020 I have two tables. One with names and addresses and a foreign key into second table that has variable information.. rates, dates, free form text, etc.. Is such a setup doable? Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted January 13, 2020 Share Posted January 13, 2020 Yes, the one with the names and addresses and foreign key is your main data source for the job, and the second table with the variable information is what we call an External Data File, or XDF. This is a very common use case. If you have FP 11, there's a tutorial template Statement-MultiFile.pdf which demonstrates this. Otherwise, you can search the User Guide, the Rules Guide, and this forum for ExternalDataFileEx for many examples. Or feel free to post the data here and someone can probably help you get started. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.