coolcatkelso
Registered User.
- Local time
- Today, 23:57
- Joined
- Jan 5, 2009
- Messages
- 279
Hiya guys
I'm adding a new table / form into my existing DBase and not sure how to arrange it
The main table / form in the Dbase is Customers, ref by CustomerID and the whole Dbase uses this for its record links.
The new area I want to add in is called "Annual Checks"
The business I have is a roofing company and we offer annual roof checks complete with roof report and photos of any damage etc, I would like to add this somewhere into the Dbase.
The main part should hold the basic details :-
ReportID or AnnualID etc
CustomerID (Number)
StartDate (Med Date)
Notes
I would need another part maybe using tabs or a button to open a "Roof Report".
The Roof Report would need to hold yes / no boxes, be only for that customer and be able to add 1 - 2 new reports every year (Perhaps every 6 months)
Any suggestions how I would do it?
any problems I could run into?
Cheers
________
New Mexico Dispensaries
I'm adding a new table / form into my existing DBase and not sure how to arrange it
The main table / form in the Dbase is Customers, ref by CustomerID and the whole Dbase uses this for its record links.
The new area I want to add in is called "Annual Checks"
The business I have is a roofing company and we offer annual roof checks complete with roof report and photos of any damage etc, I would like to add this somewhere into the Dbase.
The main part should hold the basic details :-
ReportID or AnnualID etc
CustomerID (Number)
StartDate (Med Date)
Notes
I would need another part maybe using tabs or a button to open a "Roof Report".
The Roof Report would need to hold yes / no boxes, be only for that customer and be able to add 1 - 2 new reports every year (Perhaps every 6 months)
Any suggestions how I would do it?
any problems I could run into?
Cheers
________
New Mexico Dispensaries
Last edited:
