Link tables together on multiple fields

[#1]

Hi All

Please see attached a partial view of my table structure. I have some tables linked on Date1 and some linked on the user_id, however the Transaction table, bottom left, also has a 'Transaction Date' field which i would like to link to 'Date1'. This however will cause a circular link issue.

How would i structure / link the transaction table so that i can filter by Date1 in my graphs and have the data out of the transaction table display accordingly.

Thanks

JP

[#2]

You can try the following:

To the UserTransaction table join Date1 from RegisteredUser table and then create a composite key with TransactionID and Date in both Transaction and UserTransaction table to link them

Thanks