Howdy everyone
I have a form which a user inputs information regarding overtime periods that they work. Only some of the fields are required (start time, end time, etc) and the other fields can be left blank. This form spreads the information it collects over 8 different tables that all have one-to-one relationships (with referential integrity enforced) with the table containing the "main details" of that overtime period.
If the user doesn't have any information that pertains to the data stored on one (or more) of the tables, then no record is created for that table.
Then, I have a second form with a main form and a subform that shows all of the overtime periods for a specific date. If a record does not contain information on ALL of the tables, then that record does not show up on the subform.
Again, not all of the information is REQUIRED because not all of it applies to EVERY overtime period. I need to get the subform to show ALL of the records, even if there is no applicable data stored on one or more of the tables. But I don't want to create a bunch of blank records on table if there is nothing applicable to that table.
What am I doing wrong?
Thanks in advance for the help