Jump to content

Reporting on multiple TO of the same table.


This topic is 5725 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have four tables. The first one is titled Consumer. The others are Payments, House, and Vehicle. I've attached an image to show the relationship. My question is, If I wanted to do a search of all the payments a consumer has mad across all TO's, HOW DO I DO THAT?


Link to comment
Share on other sites

Why have a table for both houses and vehicles, they're all something you rent/lease or gradualy becomes the proprietor of.

I do here see a many2many relationship where the amount paid is registered in the jointable, but all the different things that each consumer pays to get access to be it either bricks or merchandice, this will also open up for timeshares or several users.

Another thing you could store in the join-table is what type of thing the payment is covering morgage or fuel.

This make reporting pretty easy a GTRR form either the item or the consumer makes a found set in the jointable, which can be constrained to show say only fuel, in a summary.

So all in all, are the relationships you have desided to use inconvenient for estabishing the "consumption" or payment made, they might have other excellent uses ...which just escapes me.

Perhaps if you call the join table transactions it get's you on the track?

consumer ------thing_at_disposal


Edited by Guest
Link to comment
Share on other sites

This topic is 5725 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.