I run a roofing contracting business and I’m trying to transition from using Excel to Access but I’m having problems understanding how to get this situation to work.
We work on multiple Building Projects, each Project has multiple houses, each house has multiple orders made for it.
I understand how to set up a one to many relationship for a basic Customer table to Order table relationship, but I can’t seem to figure out how to set one up in my situation.
I’ve been scratching my head trying to work this out for 2 days now, could anyone offer some help on what tables and relationships to set up? Thank you