One to Many tables? What am I missing
Im trying to create a database with several nested one to many relationships. Before my Relationship Chart starts looking
like a third-world power grid, heres my question. Because I cannot connect a table to more than one relationship, I have duplicated the tables in the relationship matrix.
Now my relationships and pull downs dont work on the end form: Work Record [Portal: Items]... They work on the Work Request, the Equipment Add Form, and the main Work Record Form, but the Portal is not working.