Creating Main Form w/ SubForm from Several Tables

[GreenshootProgrammer]

Hi, I know how to create a form with a subform. However I am having difficulties creating it for this powertools database system. The system is based around customers loaning tools for a couple of days then returning them. I basically want the customers details in the main form and the tool details in the subform. I have attached an image of the relationships. How should I go about creating this main form w/ subform for this system?

 

[boblarson]

Your main form can EITHER be the tblMember table OR the tblMemberTool. It all depends on whether you would be selecting a customer and then selecting which tool(s) they were loaned. Or if you select the tool first and then select which Customers are being loaned them.

The subform would be the other one of those. And actually your tblLoan table, the way it is currently built, should really just be a part of the tblMemberTool table.

The rest have no bearing on it and should not be in any of the form record sources. They can be used with combo boxes to display the info based on the ID's from the stored values.