Error in file links

[Flupke]

Hello everyone!

In an Access database, I have three tables: tblAction, tblSale and
tblIncome.
In both tblSale and tblIncome, there is a field Action. I have set up two
relations:
between tblSale.Action and tblAction.Action_id and
between tblIncome.Action and tblAction.Action_id

I have a problem creating a report. When I want to display all the data
from tblSale as well as those from tblIncome, both linked with tblAction, I
get an error saying:
"Error in file links. Warning: fields in the report from the file
'tblIncome' cannot be linked".
When I delete one of both links the report displays fine each way. I just
cannot link both tables at the same time.

Anyone has any idea what causes this problem?


Many thanks and greetings from Brugge (Bruges - Belgium),


Michel

 

[rogar]

From your description, I assume your links are:
{tblSale}->{tblAction} and
{tblIncome}->{tblAction}
There is no direct linkage between tblSale and tblIncone, and the indirect linkage via tblAction goea against the arrows. If you reverse the arrows, you will get multiple instances of Sales and Income records wherever their Actions are equal.

Unless there is some direct one-to-one or one-to-many connection between Sales and Income records, your choices are: separate reports (one can be a subreport) or
if the Sales and Income tables have the same field structure, use a UNION or UNION ALL query to return both sets of data in one report.