That stinks about your computer. I'm sorry that happened and I hope you didn't lose any important information.
I'm still working on the database. I've since decided to abandon the table based form/subform/sub-subform approach and nuked all the forms I was working on. I really didn't have much anyway. And I slightly restructured the tables and relationships and added a new junction table that houses which Standard Items are associated with which Repair Category.
I've since created new forms based on queries instead of the tables that, so far, seem to be working better. Attached is a copy of what I have so far.
There is an Edit Estimate Form that contains all the standard items related to that estimate.
And there is a View Estimates form with buttons that will take you directly to that estimates record.
Some of the things I am now working on:
- Getting the Edit Estimate form to be blank for new data entry
- Comboboxes for the subform to be able to add any items from the Standard Items table
- Get some of the other buttons hooked up and working
I think I will have some trouble though getting the Edit Estimates form to be blank so I can add in new data. I'll still have the same issue of populating the GUID's across the appropriate tables. I took a look at the Northwind DB and tried to replicate it, but I'm getting an all white form instead. Nothing on it except for form header.
If you have time and could take a look at it for me, it would be greatly appreciated.