Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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