Data Modules - Newbie questions

[jburchill]

Hello, new to data modules and not sure how they work or what they are used for.  I have been watching youtube videos and they make it look so easy.

I am trying to create a simple data module just to see how they work and start playing around.  I am trying to create a join/relationship between two packages.  1.  Accounts Payable and 2. Accounts receivable.  I click create new relationship, but I can only select one table in the join.  What am I doing wrong?

If I try to create a join from 1 package, just different tables within.  I don't even have the option to create a relationship? 

[dougp]

Code Select Expand

I am trying to create a join/relationship between two packages...  What am I doing wrong?
Either:

• Using packages
• Not defining your data needs

In the data module, create tables from the contents of each package.  The tables should include only what you need for the reports the data module serves.  Then you can create relationships between the tables.  To reduce confusion for the report developer, be sure to not expose the items the reports won't need.  (like the original packages)

If you are trying to create a monster data module that serves up the entire content of two large or complex packages, you'll need to make the joins in the reports.